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