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