Excel’s VLOOKUP vs INDEX-MATCH Functions

by Charley Kyd on November 15, 2010

(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:

[click to continue]

Previous post:

Next post: