VLOOKUP and INDEX MATCH both work in older Excel workbooks. VLOOKUP is straightforward when the key is the leftmost column and you need one result to the right. INDEX MATCH is more flexible for leftward lookups and for returning several separate fields from one key.
Simple exact-match example
For an ID in G2 and a table in A2:C100, use =VLOOKUP(G2,A2:C100,2,FALSE) or =INDEX(B2:B100,MATCH(G2,A2:A100,0)). Both return the corresponding value from column B for a matching ID.
Leftward lookups
VLOOKUP cannot directly return a column to the left of its first lookup column. INDEX MATCH can: =INDEX(A2:A100,MATCH(G2,C2:C100,0)) finds the ID in column C and returns the corresponding name from column A.
Reuse a MATCH result
If one ID must populate price, buyer and stock in separate cells, calculate =MATCH(G2,A2:A100,0) in a helper cell, then point several INDEX formulas at that position. This avoids repeating the same key search in each formula.
Avoid approximate-match surprises
VLOOKUP defaults to approximate matching when the fourth argument is omitted. MATCH also defaults to approximate matching when the third argument is omitted. Always specify FALSE or 0 for ordinary exact-ID lookups.
When to keep VLOOKUP
If an existing Excel 2016 or 2019 workbook uses stable, correct VLOOKUP formulas for a single rightward return, rewriting every formula may add risk without providing a meaningful benefit.
Try the matching tools
Build a formula with the Excel formula builder, VLOOKUP generator, or XLOOKUP generator. Browse the formula guides for related problems.
Frequently asked questions
Is INDEX MATCH more flexible than VLOOKUP?
Yes. INDEX MATCH supports left lookups and can use separate lookup and return ranges.
Does INDEX MATCH always calculate faster?
Not always. Performance depends on workbook structure, range size and whether a MATCH result is reused.