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