Need help with iserror

[markaxtell]

Hi,

I was wondering if anyone could help with addding a iserror to the following

{=INDEX(Data!$D$1:$D$433,MATCH(C5,IF(Data!$C$1:$C$433=$F$4,Data!$A$1:$A$433),0))}

I have to press ctrl+shift+enter when entering the formula so will iserror work with this?

Many thanks in advance.

 

[Scott Huish]

Prior to XL2007, you can't use whole columns in array formulas. So just increase all the references that end in 433 to a higher row value.