everblazing
Board Regular
- Joined
- Sep 18, 2015
- Messages
- 156
Hi
I was wondering, is there a way to use data validation list drop down, which selecting different cell drop down list values would show us a name or a result of the selected group?
eg.
A2 B2 C2 D2
Apple coke hair Result
orange Fanta eyes
So if Orange, Fanta, Hair is selected from each drop down lists the name of that group I want to show in cell D2.
i know how tomake names usind sheet2 data entered.
but what i don't know is what formula do i have to use in cell D2 to show the name of that selected groupo if it was to be selected from each drop down list A2, B2, C2?
appreciate any help.
I was wondering, is there a way to use data validation list drop down, which selecting different cell drop down list values would show us a name or a result of the selected group?
eg.
A2 B2 C2 D2
Apple coke hair Result
orange Fanta eyes
So if Orange, Fanta, Hair is selected from each drop down lists the name of that group I want to show in cell D2.
i know how tomake names usind sheet2 data entered.
but what i don't know is what formula do i have to use in cell D2 to show the name of that selected groupo if it was to be selected from each drop down list A2, B2, C2?
appreciate any help.