Data validation to show name of group.

[everblazing]

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.

 

[everblazing]

Hi. Where are the data for "name of the group of categories selected" and how do they look like?

Hi Smallxyz

Have you had a chance to look at the data I have uploaded?