This is one of those problems that isdifficult with VLOOKUP, but easy withINDEX and MATCHorXLOOKUP.
Both options are explained below.
The result from MATCH is 3, since the ID 1003 occurs in the third row of the table.
This value is returned directly to theINDEX functionasrow_num.
The only difference is the array given to INDEX.
Locking references
The formulas above use normal references to make them easier to read.
you’ve got the option to use INDEX to retrieve individual values, or entire rows and columns.
MATCH supports approximate and exact matching, andwildcards(* ?)
