GUIDE深度 · Deep dive
VLOOKUP and INDEX/MATCH
VLOOKUP searches the first column of a range and returns a chosen column; the last argument FALSE/0 means exact match. INDEX/MATCH is more flexible: MATCH finds the position, INDEX returns the value there.
VLOOKUP
=VLOOKUP(lookup, range, column index, FALSE).
The lookup value must be in the first column.
INDEX/MATCH
MATCH(value, lookup column, 0) returns position.
INDEX(return column, position) returns the value.
FAQ
What is #N/A?
No match; check spelling, spaces and exact match.
Can VLOOKUP look left?
No; use INDEX/MATCH.