Excel Problem - Using ISERROR with INDEX & MATCH

[Egon]

Calling all Excel boffins...

I'm 99% to where I need to be but can't figure this last bit out. I want to return blank rather than #N/A if a match can't be made. Here is formula so far:

{=INDEX(NovResults,MATCH(E2,November!$A$11:November!$A$17&" "&November!$B$11:November!$B$17,0))}

I've tried:

{=IF(ISERROR(INDEX(NovResults,MATCH(E2,November!$A$11:November!$A$17&" "&November!$B$11:November!$B$17,0))),"")}

Which almost worked as it turned all errors in to blanks, but also made the legitimate matches return FALSE.

...help!

 

[Egon]

NVM

Problem solved, changed =IF(ISERROR to just =IFERROR, so formula now reads:

{=IFERROR(INDEX(NovResults,MATCH(E2,November!$A $11:November!$A$17&" "&November!$B$11:November!$B$17,0)),"")}