Google Sheets VLOOKUP Tutorial — Complete Guide with Examples 2027

VLOOKUP Syntax

VLOOKUP(search_key, range, index, [is_sorted]) — searches for a value in the first column of a range and returns a value from a specified column.

Example: =VLOOKUP(A2, Products!A:C, 3, FALSE) — looks up the value in A2 in the Products sheet and returns the price from column 3.

Always use FALSE for the last parameter (exact match) unless you specifically need approximate matching for ranges.

Business Examples

Product Price Lookup: Enter a product code, automatically fetch the price from the product catalog.

Customer Info: Enter a customer ID, pull name, phone, and address from the customer database.

Employee Department: Look up which department an employee belongs to based on their ID.

Tax Rate: Use approximate match (TRUE) to find the correct tax bracket based on income amount.

Common Errors and Fixes

#N/A: Value not found. Check for extra spaces (use TRIM), case sensitivity, or data type mismatch (number vs text).

#REF: Column index is larger than the range. Make sure your range includes enough columns.

#VALUE: Invalid arguments. Check that column_index is a positive number.

Pro tip: Wrap VLOOKUP in IFERROR to show a friendly message instead of error: =IFERROR(VLOOKUP(...), "Not found")

Modern Alternatives

INDEX/MATCH: More flexible than VLOOKUP. Can look up to the left, and column insertions do not break the formula.

XLOOKUP: Available in Google Sheets since 2023. Simpler syntax: =XLOOKUP(search, lookup_range, return_range).

FILTER: Returns all matching rows, not just the first match. Great for one-to-many lookups.