Excel Lookup

An easy example that shows you how to use the LOOKUP function in Excel. Not to be confused with the VLOOKUP function! The LOOKUP function is easier to use.

Lookup Example

Assume you own a company that sells chairs, tables, printers and computers. You've got a long list of order id's in one column and the corresponding products of each order in another column.

1. Open the accompanied Excel file.

You want a function that tells you quickly which product belongs to an order ID.

Lookup Function

Ready to use the LOOKUP function?

1. Before you start, make sure that the order id's are sorted in ascending order (here already done).

2. Type in =LOOKUP(

Don't be overwhelmed at this point, the Lookup function is easy. We will use the first option by entering three parameters.

3. Enter the lookup value (D3).

4. Enter the lookup_vector (A2:A58).

5. Enter the result_vector (B2:B58).

Result:

Did you like this free Excel tutorial? Show your appreciation, vote for us.

Thank you very much! We've got many more free Excel tutorials for you. Read on, learn, and enjoy!

Go to Top: Excel Lookup    |    Go to Next Tutorial: Excel Sumif