How to VLOOKUP with drop down list in Excel?

In Excel, VLOOKUP and drop down list are two useful functions. However, have you tried to VLOOKUP with drop down list? For example, you have a drop down list in a range, and when you select one kind of the fruits from the drop down list, the relative price will be shown in the adjacent cell as below screenshot shown. Now this tutorial will tell you VLOOKUP with drop down list.
VLOOKUP with drop down list

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:

Tip:

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.