Menu
Ask a question Report

IF iserror with 2 cells match [Solved/Closed]

- - Latest reply: Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
 - Oct 30, 2009 at 01:54 AM
Excel Ask a question Report
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 

1 reply

Report
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
 305
-1
Thank you
Hello

Instead of =IF(ISERROR(MATCH(C13&D13,8:8&9:9,0)),"W","L")

try =IF(MATCH(C13,8:8,FALSE)=MATCH(D13,9:9,FALSE),"W","L")
Ask a question