Excel Forumla Help Please! What am I doing wrong?

D

Dan C.

=IF(ISNA(MATCH(B1,Sheet1:Sheet2!B:B)),"No Match","Match")

This formula searches to see if (X) is on sheet 1 or sheet 2. I need it too
search sheet1 and sheet2 too see if it is on both. Anyone help?
 
J

Jim Thomlinson

=IF(OR(ISNA(MATCH(B1,Sheet1!B:B)), ISNA(MATCH(B1,Sheet2!B:B))),"No
Match","Match")
 
D

Don Guillett

=IF(ISNA(MATCH(B17,Sheet1!A:A,0)),"not on 1","on 1")&"
"&IF(ISNA(MATCH(B17,Sheet2!A:A,0)),"not on 2","on 2")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complex match 1
make formula look at diff sheet 5
more re index and match 6
Cross-Referencng numbers between worksheets 3
Auto Generate Sorting table(empty cell)?? 1
How Do I Make Vlookup Continue Looking 0
IF Statement Problem 4
Need Quick Macro Help! 2

Top