VLOOKUP
Look up a value in the first column of a range and return a value from another column in the same row.
VLOOKUP searches for a key in the leftmost column of a table and returns a value from a column you specify. It is the classic lookup function — best when your lookup column sits to the left of the data you want back.
Excel
=VLOOKUP(D2, A:B, 2, FALSE)Google Sheets
=VLOOKUP(D2, A:B, 2, FALSE)How it works
- 1D2 is the value you are searching for.
- 2A:B is the table; the lookup happens in column A.
- 32 returns the value from the 2nd column (B).
- 4FALSE forces an exact match.