So i know how to vlookup for a single return, but that's not really helping me want i want to do. I'd like to return a vertical array that lists every name that met a specified criteria. So for instance you are planning a banquet and you want to know the names of people that chose a certain meal.
Name Food Choice
Mrs. Red A
Mr Brown B
Mrs. Blue A
Mr. Green A
Mrs. White C
Mr. Black C
Mrs. Pink B
Mr. Purple A
So what formula do i use to make a name list of the people who chose A? If i do VLOOKUP("A", A2:B8, 1). That's not going to return each name in a list...any help? Thanks!
Bookmarks