Posted to microsoft.public.excel.worksheet.functions
|
|
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"
|