Excel - IF is error with 2 cells match

April 2018


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.
Published by aakai1056. Latest update on January 11, 2010 at 11:19 AM by aakai1056.
This document, titled "Excel - IF is error with 2 cells match," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
Excel - A macro for deleting row on condition
Excel - A macro to highlight duplicate values