Loading…
Loading…
VLOOKUP searches the first column of a table for a value and returns the value from another column in the same row. Use FALSE as the last argument for an exact match.
Syntax
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Example: =VLOOKUP("P102",A2:D6,3,FALSE) returns the price of P102.
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.