Download Article
Download Article
X
wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, 17 people, some anonymous, worked to edit and improve it over time.
This article has been viewed 322,922 times.
Learn more...
Whenever you keep track of data in spreadsheets, there'll come a time when you want to find information without having to scroll through endless columns or rows. We'll show you how to use Microsoft Excel's LOOKUP function to find a value from one row or column in a different row or column. If you're looking to do a reverse Vlookup, check out How to Do a Reverse Vlookup in Google Sheets.
Steps
Download Article
-
Create a two column list toward the bottom of the page. In this example, one column has numbers and the other has random words. -
Decide on cell that you would like the user to select from, this is where a drop down list will be.Advertisement -
Once you click on the cell, the border should darken, select the DATA tab on the tool bar, then select VALIDATION. -
A pop up should appear, in the ALLOW list pick LIST. -
Now to pick your source, in other words your first column, select the button with the red arrow. -
Select the first column of your list and press enter and click OK when the data validation window appears, now you should see a box with an arrow on, if you click on it your list should drop down. -
Select another box where you want the other information to show up. -
Once you clicked that box, go to the INSERT tab and FUNCTION. -
Once the box pops up, select LOOKUP & REFERENCE from the category list. -
Find LOOKUP in the list and double-click it, another box should appear click OK. -
For the lookup_value select the cell with the drop down list. -
For the Lookup_vector select the first column of your list. -
For the Result_vector select the second column. -
Now whenever you pick something from the drop down list the info should automatically change.
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Video
Tips
-
Whenever you are completed you can change the font color to white, to make the list hidden.Thanks
-
Save your work constantly, especially if the list is extensiveThanks
-
Make sure when you are in the DATA VALIDATION window (Step 5) the box labeled IN-CELL DROPDOWN is checkedThanks
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
Advertisement
About This Article
Thanks to all authors for creating a page that has been read 322,922 times.
Is this article up to date?
Advertisement
