Is it possible in Excel 2007 to look for a value in column A, then look through column B, for a certain value as long as column A matches the original lookup value?
Here is an example to illustrate what I'm trying to do.
Column A contains fruit and Column B contains either a "1" or a "0".
If my lookup value for Column A is "apple", I want to search Column B for a "1" in all rows where Column A = "apple". If it finds a "1", the search can end and the result should be "1"; if it doesn't find a "1", the result should be "0".
I tried the lookup function but it kicks out as soon as it finds a match in Column A. Sometimes it returns the "1" and sometimes it returns "0". I need to know if any of the apples has a "1" in it.
Worksheet contents:
apple 0
apple 1
apple 0
apple 0
apple 0
orange 0
orange 0
orange 0
pear 0
pear 0
pear 0
pear 0
pear 1
Results I'm looking for:
apple 1
orange 0
pear 1
Bookmarks