(Part 1 of 5. See Part 2.)
Excel offers two primary lookup methods: VLOOKUP and INDEX-MATCH. Although the two methods are similar, INDEX-MATCH is more powerful.
I suspect, however, that VLOOKUP is better-known and more widely used. Here’s one indication: Google currently shows about 500,000 results for Excel VLOOKUP and only about 25,000 for Excel “INDEX MATCH”.
In the next several posts I’ll explain VLOOKUP. Then INDEX-MATCH. And along the way, I’ll explain the advantages and disadvantages of the two methods.
There are, of course, two additional lookup functions: