Download Article
Download Article
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 321,125 times.
Advertisement
