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