Look for match on two worksheets

G

Guest

I have this formula that looks for a match on another worksheet:

=IF(ISNA(MATCH(F8,NSN6!A:A,0)),"N/A",INDEX(NSN6!D:D,MATCH(F8,NSN6!A:A,0)))

I need this scenario added to the formula: First look at NSN6 for match.
If found, input match. If no match found, look on NSN5 for match. If found,
input match. If not found on either worksheet, input N/A.
 
B

Biff

Hi!

One way:

=IF(COUNTIF(NSN6!A:A,F8)+COUNTIF(NSN5!A:A,F8)=0,"N/A",IF(COUNTIF(NSN6!A:A,F8),INDEX(NSN6!D:D,MATCH(F8,NSN6!A:A,0)),INDEX(NSN5!D:D,MATCH(F8,NSN5!A:A,0))))

Biff
 
G

Guest

That did it.

Thanks again.

Biff said:
Hi!

One way:

=IF(COUNTIF(NSN6!A:A,F8)+COUNTIF(NSN5!A:A,F8)=0,"N/A",IF(COUNTIF(NSN6!A:A,F8),INDEX(NSN6!D:D,MATCH(F8,NSN6!A:A,0)),INDEX(NSN5!D:D,MATCH(F8,NSN5!A:A,0))))

Biff
Click to expand...
 

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

IF NOT FOUND 5
Correct #N/A Value 6
With F1 value, look at A, if match or partial match return B 5
Modify and add extra condition 2
Match and Vlookup issue 2
Conditional Indexing 2
match formula 2
Formula Using Vlookup & Match 3

Top