Lookup & Referenceintermediate
VLOOKUP to match two columns
=VLOOKUP(A2,$F$2:$G$8,2,FALSE)
Google Sheets reference
VLOOKUP in Google Sheets
Works in Google Sheets1 worked example
Worked examples (1)
These formulas work in Google Sheets with identical syntax.
Also in Excel
See the full VLOOKUP reference for Excel — including all worked examples, common errors, and FAQ.
VLOOKUP Excel reference →