![]() ![]() Then click Enter key and the relative price is shown. 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. Now you want to use VLOOKUP to get the relative price of selected fruit.ġ. Now this tutorial will tell you VLOOKUP with drop down list.Īctually, the VLOOKUP function also work when the look up value is in a drop down list.įor example, you have a range of data as below screenshot shown:Īnd then you create a drop down list based on above data. ![]() 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. ![]() In Excel, VLOOKUP and drop down list are two useful functions. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |