Difference between revisions of "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.<br><br>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?

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.<br><br>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?

== Steps ==

== Steps ==

#Create a two column list toward the bottom of the page. In this example, one column has numbers and the other has random words.

#Create a two column list toward the bottom of the page. In this example, one column has numbers and the other has random words.