Excel Function

LOOKUP

Performs vector lookup in sorted data.

LOOKUP(lookup_value, lookup_vector, [result_vector])

Arguments

lookup_value

Required

Enter the value you want to look up.

lookup_vector

Required

Specify a reference range. You can drag or click start/end cells.

result_vector

Optional

Specify a reference range. You can drag or click start/end cells.

Practice Preview

Use LOOKUP to return the result with these settings (Lookup value: B2 (cell B2 (Product Name in column B)), Lookup vector: B2:B8 (Product Name in column B), Result vector: D2:D8 (Stock in column D)). 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)

=LOOKUP(B2, B2:B8, D2:D8)

Result

Practice This Function

Start Function Practice Back to Function List

LOOKUP FAQ

How do I use LOOKUP in Excel?

Use LOOKUP when you want to return a nearby value from ordered data. Enter Lookup value, Lookup vector, Result vector in that order, then add optional arguments when needed.

Where can I practice LOOKUP?

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

What arguments does LOOKUP use?

The main arguments are Lookup value, Lookup vector, Result vector. Start with the required ones, then add optional arguments if needed.