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}
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}