How to Use the Lookup Function in Excel


Whenever you keep track of anything with spreadsheets, there'll come a time when you want to find information without having to scroll through a list. That's when the LOOKUP function can be useful. Let's say you have a simple list of 1000 clients with three columns: last name, phone number, and age. If you want to find the phone number for Monique Wikihow, you can look at every name in that column till you find it. To speed things up, you can sort the names alphabetically, but if you have many clients with last names starting with "w", you might still get a headache browsing the list. Using the LOOKUP function, however, you can simply type in the name and the spreadsheet will spit out Miss wikiHow's phone number and age. Sounds handy, doesn't it?

Part 1

 on How to Use the Lookup Function in Excel

1
In this example, one column has numbers and the other has random words.

 on How to Use the Lookup Function in Excel

2

 on How to Use the Lookup Function in Excel

3

 on How to Use the Lookup Function in Excel

4

 on How to Use the Lookup Function in Excel

5

 on How to Use the Lookup Function in Excel

6

 on How to Use the Lookup Function in Excel

7

 on How to Use the Lookup Function in Excel

8

 on How to Use the Lookup Function in Excel

9

 on How to Use the Lookup Function in Excel

10

 on How to Use the Lookup Function in Excel

11

 on How to Use the Lookup Function in Excel

12

 on How to Use the Lookup Function in Excel

13

 on How to Use the Lookup Function in Excel

14