I am looking to create a Dynamic drop down list where if I select a specific line item in the drop down, the adjacent cell will display the value that the line item is associated with.
Ex: If I select Apples, I want the next cell to display the Euros that is associated with that item from a source list. I'm assuming this can be solved by an "If" statement, but not 100% sure.
CodePudding user response:
Just use an INDEX:
=INDEX("The Range where the prices are listed",$D$15)
With D15 being the output of your Dropdown list
CodePudding user response:
Here's an example using VLOOKUP
.
In column A are all the drop-down values, as defined by the range E2:E5.
In column B is the formula =IFNA(VLOOKUP(A2,$E$2:$F$5,2,FALSE),"--")