US Trends

what is vlookup in excel

VLOOKUP in Excel is a 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.

What VLOOKUP Does (Quick Scoop)

Think of VLOOKUP as asking Excel:
“Find this value in the first column of my table, and tell me what’s in column X of the same row.”

  • It searches vertically (the V in VLOOKUP stands for “Vertical”).
  • It always looks in the first column of your selected range.
  • It returns data from a column to the right of that first column.

A simple example:
You have a list of product IDs in column A and prices in column B. You can use VLOOKUP to type a product ID and instantly get its price.

Basic Syntax (How It Looks)

The standard syntax is:

=VLOOKUP(lookup\_value,\table\_array,\col\_index\_num,\[range\_lookup])

  • lookup_value : What you’re searching for (e.g., product ID, employee ID).
  • table_array : The full table where Excel will look (must include the first column with the lookup_value and the columns with results).
  • col_index_num : The column number (within the table_array) that you want to pull data from, counting from the left.
  • range_lookup :
    • FALSE or 0 = exact match (most common and safest).
* TRUE or 1 = approximate match (table usually must be sorted).

Mini Example Formula

=VLOOKUP("P123", A2:C100, 3, FALSE)

  • Looks for "P123" in the first column of A2:C100 (that’s column A).
  • When it finds "P123", it returns the value from the 3rd column in that range (column C).
  • FALSE means “only if you find an exact match.”

When You’d Use VLOOKUP (Real-Life Style)

Common situations:

  • Getting a product price from a product ID list.
  • Fetching an employee’s department from their ID.
  • Linking information between two sheets (e.g., master list and a report).

In modern Excel, many experts now prefer newer functions like XLOOKUP or combinations of INDEX + MATCH because they’re more flexible, but VLOOKUP is still extremely common and widely used in businesses.

Tiny “Forum-Style” Tip

“First off, probably don’t use VLOOKUP. There’s almost always something better…” – a typical Excel forum take, because functions like XLOOKUP and INDEX/MATCH can do more and avoid some of VLOOKUP’s limitations.

But if you’re just starting and asking “what is VLOOKUP in Excel,” learning VLOOKUP is still a very helpful step before moving on to those newer tools.

TL;DR: VLOOKUP is a vertical lookup function in Excel that finds a value in the first column of a range and returns related data from another column in the same row, using the syntax =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).