Formula Library
VLOOKUP
lookupSearches for a value in the first column of a range and returns a value in the same row from another column.
Syntax
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])Example
Excel
=VLOOKUP(A2, D:F, 2, FALSE)Looks up the value in A2 within column D, returns the corresponding value from the 2nd column (E) of the range D:F.
Tips & Notes
- →Use FALSE for exact match (most common)
- →Column index starts at 1, not 0
- →The lookup column must be the leftmost column in your range
See Also
Need a custom VLOOKUP formula?
Describe exactly what you need and get the formula generated instantly.