Mastering VLOOKUP

VLOOKUP (Vertical Lookup) is one of Excel’s most iconic functions. It allows you to search for a value in the first column of a table range and return a value in the same row from another column.

Syntax

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

• lookup_value: What you want to look up.
• table_array: Where you want to look for it.
• col_index_num: The column number in the range containing the value to return.
• range_lookup: Optional. TRUE for approximate match, FALSE for exact match.

Common Pitfalls

1. Left-to-Right Limitation: VLOOKUP can only look to the right. It cannot return values from columns to the left of the lookup column.
2. Column Insertion: If you insert a new column in your table, your col_index_num might break if hardcoded.

Always use FALSE (or 0) for exact text matches to avoid unexpected results.