How to get values when selecting from dropdown list

[jin0109]

Hi,

I am wondering which formulas i should use for this.
For example, if i select "Yes" from the dropdown list, i want to get "Apple". If i select "No" from the dropdown list, i want to get "Orange".

Please refer to attached file.

Thank you.

[Pete_UK]

You could use this in B1:

=IFERROR(VLOOKUP(A1,A3:F5,6,0),"")

Hope this helps.

Pete

[jin0109]

Hi Pete,
How about when i want to choose different values when selecting from the dropdown list?
For example, when i select "Yes", how can i get "banana"? should i use "if"?

Thank you so much for your help in advance!

[Pete_UK]

I think what you are trying to describe is what is called dependent data validation, e.g. you select "Fruit" in one drop-down (rather than "vegetable"), and then in another drop-down you can select from a list of fruits, but if you had selected vegetable in the first drop-down then the second drop-down would automatically present you with a list of vegetables that you could choose from.

Is that what you are after?

Pete

[jin0109]

Yes thank you so much Pete!

[Pete_UK]

Okay, well Debra Dalgleish has an excellent section on dependent data validation on her website here:

https://www.contextures.com/xlDataVal02.html

That will explain everything you need to know to set it all up.

Hope this helps.

Pete