Hi,

I have a spreadsheet of people and - say - the foods they like.

Name Pizza Ice Cream Pasta Bread
Joe x x
Mary x x
Will x x
Ed x x

Suppose I want to cook a dinner and I want to find all the people
who like Ice Cream, or Pasta...how do I go about that?

Thanks.
Spookyleela

I've given your table the named range Dining A1:E5

A10 = Mary
B10 = Pasta
C10 = =VLOOKUP(A10, Dining, MATCH(B10, OFFSET(Dining, 0, 0, 1), 0), FALSE) =
"x"

--
Rob van Gelder - http://www.vangelder.co.nz/


wrote in message
oups.com...
Hi,

I have a spreadsheet of people and - say - the foods they like.

Name Pizza Ice Cream Pasta Bread
Joe x x
Mary x x
Will x x
Ed x x

Suppose I want to cook a dinner and I want to find all the people
who like Ice Cream, or Pasta...how do I go about that?

Thanks.
Spookyleela

Thanks Rob, but that's not what I had in mind.
I want to build a form where I check for example pasta
and that would return the names of the individuals who
will eat that.
Your function returns True/False on one individual.