Excel - IF is error with 2 cells match

October 2016


If I have 2 cell that i need to match to 2 array row and print "W" or "L" if both of the cell match.

This is what i have


example C13: Mike
D13: 9

Row 8 is name, if Mike is there and Row 9 is age, if age match print "W".

But my formula only seems to compared the first match.


Instead of



Thanks to Excelguru for this tip on the forum.

Related :

This document entitled « Excel - IF is error with 2 cells match » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.