Drop down list - value focus

Occasional Visitor



I am trying to connect my drop down list per value with another cell.

The dropdown has been created with a yes or no list. 

What I am trying to do is when I select yes in cell A1 that I can connect that yes to a certain value (e.g. 10 euros) and no to another value (5 euros) and these values are then shown in cell A2 


I have no clue how to work this out. Is there anyone able to explain this to my. 

Any help would be great!

3 Replies
Without more information, sound like you want to use a combination of:
Data Validation (list) and
VLOOKUP or MATCH, and INDEX functions

I hope that helps.


Here is a very simplified form




Two options. 


Straightforward if only referencing yes response. If yes then plug in €10 otherwise by default the formula will plug in €5.


The VLOOKUP is more scalable. Whatever you decide, be cognizant of absolute ($G$2:$H$3) versus relative cell references. I like using named ranges (e.g. name F2:G3 as ‘YesNo_List’). Named Ranges function as absolute cell references and can make formulas easier to follow.