Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ignore #N/A error using Index and Match Functions
Hi,
I have created the formula below with named ranges. The problem what I cant seem to figure out is that when there is no match found I get a #N/A error. I need to to show as Blank if there is not a match. =INDEX('Barcrest Daily Update.xls'!DateShipped,MATCH(1,(C2='Barcrest Daily Update.xls'!Order)*(D2='Barcrest Daily Update.xls'!Line),0)) This is entered as an array using CSE Any suggestioons please |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ignore #N/A error using Index and Match Functions
Try: =IF(ISNUMBER(MATCH(1,(C2='Barcrest Daily Update.xls'!Order)*(D2='Barcrest Daily Update.xls'!Line),0)),INDEX('Barcrest Daily Update.xls'!DateShipped,MATCH(1,(C2='Barcrest Daily Update.xls'!Order)*(D2='Barcrest Daily Update.xls'!Line),0)),"") -- NBVC Where there is a will there are many ways. 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=123914 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDEX and MATCH functions | Excel Worksheet Functions | |||
Row, Index, Match functions | Excel Discussion (Misc queries) | |||
INDEX & MATCH functions | Excel Worksheet Functions | |||
Index and Match Functions | Excel Worksheet Functions | |||
How do I use the Match and Index functions to look up a value tha. | Excel Worksheet Functions |