How to VLOOKUP with drop down list in Excel?
VLOOKUP with drop down list
Actually, the VLOOKUP function also work when the look up value is in a drop down list.
For example, you have a range of data as below screenshot shown:
And then you create a drop down list based on above data. See below screenshot:
Now you want to use VLOOKUP to get the relative price of selected fruit.
1. Select a value from the drop down list, the type this formula =VLOOKUP(E2,$A$2:$B$6,2,FALSE) into a cell adjacent the drop down list. See screenshot:
2. Then click Enter key and the relative price is shown. See screenshot:
In the above formula, E2 is the lookup value in the drop down list, A2:B6 is the data range of the original data, 2 indicates this formula will return the values in the second column of original data.
Easily create a dynamic 2-level or multiple-level dependent drop-down list in Excel
|In Excel, to create a 2-level or multiple level drop-down list is complex. Here the Dynamic Drop-down List utility of Kutools for Excel can do you a favor. What you only to do is order the data as example shown, then select the data range and output range, then leave it to the utility. Click for 30 days free trial!|
|Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.|
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!