IF iserror with 2 cells match [Solved/Closed]
Hello,
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
=IF(ISERROR(MATCH(C13&D13,8:8&9:9,0)),"W","L")
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 formular only seem to compared the first match.
thanks,
sang
See more