IF NOT FOUND
 

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,M ATCH(D9,NSN6!A:A,0)))

If data/match is not found, what is needed to say "Not Found"

IF NOT FOUND
 

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

Just change the "" in the part above to "Not Found"

i.e. change to:
=IF(ISNA(MATCH(D9,NSN6!A:A,0)),"Not Found",

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"roy.okinawa" wrote in message
...
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,M ATCH(D9,NSN6!A:A,0)))

If data/match is not found, what is needed to say "Not Found"

IF 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 ca
=IF(ISNA(MATCH(D9,NSN6!A:A,0)),"Not Found",VLOOKUP(D9,NSN6!A:B,2,0))

"roy.okinawa" wrote:

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,M ATCH(D9,NSN6!A:A,0)))

If data/match is not found, what is needed to say "Not Found"

IF NOT FOUND
 

Even better. Thanks.

"bpeltzer" wrote:

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 ca
=IF(ISNA(MATCH(D9,NSN6!A:A,0)),"Not Found",VLOOKUP(D9,NSN6!A:B,2,0))

"roy.okinawa" wrote:

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,M ATCH(D9,NSN6!A:A,0)))

If data/match is not found, what is needed to say "Not Found"

IF NOT FOUND
 

That did it. Thanks.

"Max" wrote:

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

Just change the "" in the part above to "Not Found"

i.e. change to:
=IF(ISNA(MATCH(D9,NSN6!A:A,0)),"Not Found",

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"roy.okinawa" wrote in message
...
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,M ATCH(D9,NSN6!A:A,0)))

If data/match is not found, what is needed to say "Not Found"

IF NOT FOUND
 

You're welcome !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"roy.okinawa" wrote in message
...
That did it. Thanks.