I want to return the value 'YES' where two different cells (Name & Year) match. The value should only pull through where a name has been assigned as 'YES' for certain years.
Sheet1
Name - column H
Year - column C
Sheet 2
Name - column E
Year - column A
I was using the formula below however does not work. There are certain Names which should be 'YES' for two out of three years however formula returns 'YES' for all three years.
=IF(AND(ISNUMBER(MATCH(H2,Sheet2!E:E,0)),ISNUMBER(MATCH(C2,Sheet2!A:A,0))),"YES","")
Bookmarks