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

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