What is the main limitation of VLOOKUP compared with INDEX-MATCH?
- A VLOOKUP can only search rightwards and uses a hard-coded column index
- B VLOOKUP cannot do exact matches
- C VLOOKUP only works on numbers
- D VLOOKUP is slower on small datasets
Answer
VLOOKUP can only search rightwards and uses a hard-coded column index
Inserting a column silently changes what the column index points at, returning wrong data with no error. INDEX-MATCH is immune to this.





