VLOOKUP Masterclass

VLOOKUP searches for a value in the first column of a table range and returns a value in the same row from a column you specify.

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

The 4 Arguments

• Lookup_value: What are you looking for?
• Table_array: Where is the data?
• Col_index_num: Which column has the answer?
• Range_lookup: Approximate (TRUE) or Exact (FALSE)?

Always use FALSE (or 0) for exact matches. If you omit this, Excel defaults to approximate match, which can lead to wrong data!

Example

Finding a price based on Product ID:

=VLOOKUP(H2, A2:D100, 3, FALSE)