return groups of components

[Stan Altshuller]

Hi All,

I have a challenging (for me) problem in excel.
I have a spreadsheet with names of groups running across (row 2:2)
running down column B:B I have names of components.

I would like to have a function for each component, returning the groups
that the componnent is in.

EX: (in my spread sheet the X is actually a number)

Group: round animal fruit solid
component:

apple X X
pear X
pig X
tree
rock X

So I would like to have a function look across the matrix for apple and have
F(apple) return: Round, Fruit

Anyhelp or ideas are GREATLY appreciated and thanks so much in advance!!

Stan

 

[Stan Altshuller]

Can this even be done??
Please someone help!! :]

 

[Bob Tarburton]

Try this (assuming "apple" is in B4 and "round" is in C2)
In G4 =trim(if(c4="","",c$2)&" "&if(d4="","",d$2)&"
"&if(e4="","",e$2)&" "&if(c4="","",e$2))

You might have to change c4="", d4="", etc to something like
OR(c4="",c4=0)
etc
depending on what other thatn a number you might have in the cells
that are not "X" in this example

Can this even be done??
Please someone help!! :]

Hi All,

I have a challenging (for me) problem in excel.
I have a spreadsheet with names of groups running across (row 2:2)
running down column B:B I have names of components.

I would like to have a function for each component, returning the groups
that the componnent is in.

EX: (in my spread sheet the X is actually a number)

Group: round animal fruit solid
component:

apple X X
pear X
pig X
tree
rock X

So I would like to have a function look across the matrix for apple and have
F(apple) return: Round, Fruit

Anyhelp or ideas are GREATLY appreciated and thanks so much in advance!!

Stan