How to Use VLOOKUP

Steps

• Identify the lookup value you want to search for in your data table.
• Select the cell where you want the result to appear and type =VLOOKUP(.
• Enter the four required arguments: lookup_value, table_array, col_index_num, and range_lookup (TRUE for approximate match, FALSE for exact match).
• Press Enter to execute the formula and retrieve the matching value.

Example Formula

Breaking Down the Formula:

• Table13[[#All],[PN]] — This is the lookup value (the Part Number from Honeywell's sheet that you're searching for).
• Table1[[#All],[Part Number]:[Acquisition Cost]] — This is the range in your sheet where the formula will search, spanning from "Part Number" to "Acquisition Cost" columns.
• 1 — This is the column index number. It tells Excel which column from the table range to return data from:
  • 1 = First column (Part Number)
  • 2 = Second column
  • 3 = Third column
  • And so on... Change this number (1-5) based on which column's data you need.
• FALSE — This ensures an exact match. Use FALSE when looking up specific values like part numbers or IDs.