fx =VLOOKUP(A1,Sheet2!A:D,3,FALSE)ABCSKU-4821Widget A$24.99SKU-7293Gadget B$89.50SKU-1056Tool C$12.75
🔍 Lookup

VLOOKUP Formula for Lookup

Look up a value in a table by matching the first column. Copy-paste ready for Excel, Google Sheets, and Airtable.

=VLOOKUP(A1,Sheet2!A:D,3,FALSE)
When you need this: When you need to find the unit price of a product (in Sheet2 price list) based on its product ID in cell A1.

How it works

  1. 1Search for the lookup value (product ID in A1) in the first column of Sheet2!A:D.
  2. 2Once found, move to the column number specified (3 = column C, the price).
  3. 3Return that price. FALSE means exact match required.

Variations

VLOOKUP with range names
=VLOOKUP(A1,PriceList,3,FALSE)
VLOOKUP with default error handling
=IFERROR(VLOOKUP(A1,Sheet2!A:D,3,FALSE),"Not Found")

Related Formulas

INDEX/MATCH — Flexible lookup - more powerful than VLOOKUPLookupXLOOKUP — Modern replacement for VLOOKUP (Excel 365)LookupFILTER — Return rows matching criteria (dynamic filter)LookupSORT — Sort a range dynamicallyLookup

Need a formula that's not here?

Generate custom formula →