Excel Function

VLOOKUP

Looks up a value in the first column and returns matching value.

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Arguments

lookup_value

Required

Enter the value you want to look up.

table_array

Required

Specify the full table range used for lookup.

col_index_num

Required

Enter the return column number in table_array (1-based).

range_lookup

Optional

Set lookup behavior. FALSE = exact match, TRUE/omitted = approximate match (lookup range must be sorted ascending).

Practice Preview

Use VLOOKUP to return the result with these settings (Lookup value: B2 (cell B2 (Product Name in column B)), Table array: B2:D8 (columns B to D), Column number: 3, Lookup mode: FALSE (exact match)). You can set ranges by dragging from the start cell to the end cell in the same argument field.

Example Table

#	AProduct ID	BProduct Name	CPrice	DStock
2	P001	Apple	120	80
3	P002	Banana	98	120
4	P003	Notebook	450	35
5	P004	Pen	300	60
6	P005	Grapes	150	45
7	P006	Ruler	250	20
8	P007	Peach	86	55

How to Use (Formula)

=VLOOKUP(B2, B2:D8, 3, FALSE)

Result

Practice This Function

Start Function Practice Back to Function List

VLOOKUP FAQ

How do I use VLOOKUP in Excel?

Enter the lookup value, table range, and return column number in order. For example, to return a price from a product name, use VLOOKUP(B2, B2:D8, 3, FALSE).

Where can I practice VLOOKUP?

Use the "Start Function Practice" button to jump straight into VLOOKUP drills.

What arguments does VLOOKUP use?

The main arguments are Lookup value, Table array, Column number, Lookup mode. Start with the required ones, then add optional arguments if needed.