Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
#5
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" |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find text in another workbook and paste if found match - VBA | Excel Discussion (Misc queries) | |||
I found reference to info that I need on Excel-how do I acess the | Charts and Charting in Excel | |||
Return text found in a search | Excel Worksheet Functions | |||
Linking files "File Not Found" | Excel Discussion (Misc queries) | |||
File not found prompting | Excel Worksheet Functions |