Ignore #N/A error using Index and Match Functions

W

winnie123

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
 
N

NBVC

Try:

=IF(ISNUMBER(MATCH(1,(C2='Barcrest Daily
Update.xls'!Order)*(D2='Barcrest Dail
Update.xls'!Line),0)),INDEX('Barcrest Dail
Update.xls'!DateShipped,MATCH(1,(C2='Barcrest Daily
Update.xls'!Order)*(D2='Barcrest Daily Update.xls'!Line),0)),""

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trying to find solution to copy duplicated data from one sheet to 12
Index Match QUestion 0
Index and Match 5
Index and match 2
MATCH returning #N/A 3
hiding an error value, using INDEX/MATCH 3
Index Match to ignore blank cells 0
How to convert #N/A to 0 using Match? 8

Top