A VLOOKUP is an Excel function that looks down the first column of a table to find a value, then returns related data from another column in the same row. The “V” stands for Vertical , because it searches vertically through rows.

Quick Scoop

VLOOKUP is most often used to:

  • Pull a price, name, or status from a big list using an ID or code.
  • Combine data from two sheets where a common key (like Product ID) exists.
  • Replace manual searching with an automatic, formula-based lookup.

Basic idea

In plain language, VLOOKUP says: “Find this value in the first column of that table, then give me the value from another column on the same row.” It always searches the leftmost column of the range and can only return data from columns to the right.

The formula

Standard syntax:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])\text{=VLOOKUP(lookup\_value, table\_array, col\_index\_num, [range\_lookup])}=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

  • lookup_value : What you’re searching for (like an ID, name, or code).
  • table_array: The full table that contains both the lookup column and the column you want to return.
  • col_index_num: The column number (within that table) to pull the result from, starting at 1 for the leftmost column.
  • range_lookup: TRUE for approximate match, FALSE for exact match (FALSE is recommended for most everyday lookups).

Simple example

Imagine a product list where column A has Product IDs and column B has Prices. To get the price for product ID P102, you could use:

=VLOOKUP("P102", A2:B100, 2, FALSE)\text{=VLOOKUP("P102", A2:B100, 2, FALSE)}=VLOOKUP("P102", A2:B100, 2, FALSE)

This tells Excel to look for “P102” in column A and return the price from column B on the same row.

Information gathered from public forums or data available on the internet and portrayed here.