help needed with multiple values
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 |
help needed with multiple values
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 |
help needed with multiple values
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. |
All times are GMT +1. The time now is 07:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com