convert formula from 2007 to 2003

[blkane]

Hi, Not eveyone in my office has moved off of Excel 2003. I need to share a workbook that has formulas that aren't in 2003. I'm looking for some help with converting these formulas to a 2003 equivalent. Thanks in advance.

I have an array formula that is indexing the range "Trend" matching specific fields and returning the value. If it doesn't find any matches, it returns a zero instead of an error. The problem is the "IFERROR". Can someone suggest a modification to the formula that is compatible with Excel 2003?

{=ROUND(IFERROR(INDEX(Trend,MATCH($B5&$C5,Cust_Name&Metric_vol,0),MATCH(F$3,Month,0)),0),0)*$E5}

 

[baitmaster]

replace IFERROR(x,y) with IF(ISERROR(x),y,x)

 

[JoeMo]

=ROUND(IF(ISERROR(INDEX(Trend,MATCH($B5&$C5,Cust_Name&Metric_vol,0),MATCH(F$3,Month,0))),0,INDEX(Trend,MATCH($B5&$C5,Cust_Name&Metric_vol,0),MATCH(F$3,Month,0))),0)*$E5

 

[blkane]

The people on this forum never disappoint. Thank you very very much. It works beautifully.