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