INDEX is the key behind the combo and it is remarkably simple. Let’s first split the two functions to see what they are both doing and see how together they make the perfect marriage of convenience. This article takes you through a range of examples where Excel’s INDEX and MATCH can help you lookup data in different ways. If you do manage to work your head around INDEX MATCH your ability to return data will be vastly improved over the VLOOKUP formula which is limited to looking up data to the right of the unique identifier. The INDEX and MATCH formula is not as heavily used in Excel because it is a nested formula, a combination and I guess users find the process a little more long winded or confusing.
0 Comments
Leave a Reply. |