Functions
VLOOKUP
Searches first column of range, returns value from index column
Try it
When to use it
When should I use VLOOKUP instead of XLOOKUP?
Use XLOOKUP when it is available — it can look left, returns a clean result when nothing is found, and does not break when columns move. Reach for VLOOKUP mainly for compatibility with older sheets.
Why does my VLOOKUP return the wrong value?
Usually because the last argument is left as approximate match. Pass FALSE as the fourth argument to force an exact match unless your lookup column is sorted and you truly want the nearest value.
Use cases
Find an employee's department by ID
Map a tier number to a discount rate
Used in
Syntax
VLOOKUP(search_key, range, index, [is_sorted])Examples
=VLOOKUP("b",{"a",1;"b",2;"c",3},2,FALSE) // => 2
=VLOOKUP("a",{"a",10;"b",20;"c",30},2,FALSE) // => 10
=VLOOKUP("c",{"a",10;"b",20;"c",30},2,FALSE) // => 30