Excel 2007 : Removing the #n/a from this index match formula

Hi All,

I have the following formula, but where there is no code match it brings back an #N/A, adn where there is a code but no cost it brings back a 0.

i am fine with the 0, but I can't get the #N/A to disappear using ISNA or IFERROR!!

Any sugestions?

=INDEX('AB Revenue'!$R$2:$AC$1048573,MATCH('Journal Sheet'!E259,'AB Revenue'!$C$2:$C$1048576,0),MATCH('Journal Sheet'!$B$253,'AB Revenue'!$R$1:$AC$1,0))

Cheers

Donna

With IFERROR you just wrap the whole formula, i.e.

=IFERROR(INDEX('AB Revenue'!$R$2:$AC$1048573,MATCH('Journal Sheet'!E259,'AB Revenue'!$C$2:$C$1048576,0),MATCH('Journal Sheet'!$B$253,'AB Revenue'!$R$1:$AC$1,0)),"")