#N/A needs to be blank

[seanrigby]

have a formula....

=INDEX('All Data sheet '!D14:E14,MATCH(A5,'All Data sheet '!D9:E9,0),MATCH(D3&E3,'All Data sheet '!D13:E13,0))

If it comes back with a #N/A in the column, how do I get it to show as a blank cell?

[daddylonglegs]

Try

IF(COUNT(MATCH(A5,'All Data sheet '!D9:E9,0)*MATCH(D3&E3,'All Data sheet '!D13:E13,0)),INDEX('All Data sheet '!D14:E14,MATCH(A5,'All Data sheet '!D9:E9,0),MATCH(D3&E3,'All Data sheet '!D13:E13,0)),"")

In older versions of Excel, or in Excel 2007

=IFERROR(INDEX('All Data sheet '!D14:E14,MATCH(A5,'All Data sheet '!D9:E9,0),MATCH(D3&E3,'All Data sheet '!D13:E13,0)),"")

[seanrigby]

Works great. Thanks for your help!