IF NOT FOUND

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking at data on one worksheet and transferring to another using the
below formula.

=IF(ISNA(MATCH(D9,NSN6!A:A,0)),"",INDEX(NSN6!B:B,MATCH(D9,NSN6!A:A,0)))

If data/match is not found, what is needed to say "Not Found"
 
Just replace the empty string in the formula you've got:
=IF(ISNA(MATCH(D9,NSN6!A:A,0)),"Not
Found",INDEX(NSN6!B:B,MATCH(D9,NSN6!A:A,0)))
BTW, you could simplify this slightly if you care:
=IF(ISNA(MATCH(D9,NSN6!A:A,0)),"Not Found",VLOOKUP(D9,NSN6!A:B,2,0))
 
Even better. Thanks.

bpeltzer said:
Just replace the empty string in the formula you've got:
=IF(ISNA(MATCH(D9,NSN6!A:A,0)),"Not
Found",INDEX(NSN6!B:B,MATCH(D9,NSN6!A:A,0)))
BTW, you could simplify this slightly if you care:
=IF(ISNA(MATCH(D9,NSN6!A:A,0)),"Not Found",VLOOKUP(D9,NSN6!A:B,2,0))
Click to expand...
 
Back
Top