The syntax of the INDEX function is straightforward: The Excel INDEX function returns a value in an array based on the row and column numbers you specify. We will cover only the minimum necessary for understanding the general idea and then take an in-depth look at formula examples that reveal all the advantages of using INDEX MATCH instead of VLOOKUP. Since the aim of this tutorial is to demonstrate an alternative way to do a vlookup in Excel by using a combination of INDEX and MATCH functions, we won't dwell much on their syntax and uses.
0 Comments
Leave a Reply. |