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]

Thank you for the formula and your time.


I was wondering is it possible to name the group of products so instead of referring to cell numbers we can refer to names? so have the ingredients that equal to product 1 whiich for example is the booster to be named in sheet2 then refer to those combined ingrediants in the formula if the combination of the drop down lists is selected from A2 to C2.

Thanks

 

[smallxyz]

So, let me try to restate the situation. Please correct for misunderstanding.

You have some named ranges for products in another sheet.

e.g.

In sheet2,

"Booster" may refer to {ingredient1, ingredient2, ingredient3}
"Lifter" may refer to {ingredient4, ingredient5, ingredient6}

Now you wanna create one summary name for these products ( i.e. Booster, Lifter ) as a group, say "Summary_Product".
And then make use of the name "Summary_Product" in the formula in sheet 1 D2 to auto-return the correct product name, according to the values of ingredient drop-down lists in A2, B2, C2?

 

[everblazing]

yes thats exactly it.

 

[smallxyz]

Well, for the formula

=INDEX($J$2:$J$7,MATCH(1,($G$2:$G$7=A2)*($H$2:$H$7=B2)*($I$2:$I$7=C2),0))

You could give name to $J$2:$J$7, $G$2:$G$7, $H$2:$H$7, $I$2:$I$7

Btw, it is hard to talk without a concrete file. Could you post a sample file?

 

[everblazing]

how do I upload a file here?

 

[smallxyz]

You may try

TinyUpload.com - best file hosting solution, with no limits, totaly free

or other free file hosting websites.

 

[everblazing]

You may try

TinyUpload.com - best file hosting solution, with no limits, totaly free

or other free file hosting websites.

I have managed to upload the file here,
TinyUpload.com - best file hosting solution, with no limits, totaly free

 

[everblazing]

apologies here's the file

TinyUpload.com - best file hosting solution, with no limits, totaly free

 

[smallxyz]

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

 

[everblazing]

Hi, Here is the data.

thanks
TinyUpload.com - best file hosting solution, with no limits, totaly free

look forward to your response.