IF iserror with 2 cells match [Solved/Closed]

Question

IF iserror with 2 cells match [Solved/Closed]

Report

sangng978 - Oct 27, 2009 at 11:56 AM
Excelguru

Posts: 261
Registration date: Saturday April 11, 2009
Status: Member
Last seen: June 21, 2011

- Oct 30, 2009 at 01:54 AM

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

IF iserror with 2 cells match
Excel - IF is error with 2 cells match - How-To - Excel
Match 2 cells and return value in third ✓ - Forum - Excel
Excel lookup 2 cells to match in 2 rows. ✓ - Forum - Excel
Perform a Partial Cell Match in Excel - How-To - Excel
VBA - Using the IF function for 2 cells - How-To - Excel

1 reply

Ask a question

Excelguru · Answer 1 · 2009-10-30T01:54:34-0400

Answer 1 / 1

Excelguru

Posts: 261
Registration date: Saturday April 11, 2009
Status: Member
Last seen: June 21, 2011

307
Oct 30, 2009 at 01:54 AM

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")

IF iserror with 2 cells match [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!