1
In Excel 2010 the forulma I am using is:
=_xlfn.IFERROR(INDEX(K$76:K$2044,MATCH(Q23,P$76:P$2044,0),1),INDEX(K$76:K$2044,MATCH(Q23,L$76:L$2044,0),1))
But I need to convert it to excel 2003. I have figured out:
_xlfn.IFERROR
Becomes
_IF(ISERROR)
So in Excel 2003 the formula is now:
=IF(ISERROR(INDEX(K$76:K$2044,MATCH(Q23,P$76:P$2044,0),1),INDEX(K$76:K$2044,MATCH(Q23,L$76:L$2044,0),1)))
But there are too many agruments for 2003 to handle. Could anyone help to shorten or simplify the formula?
I really like your explaining what the formula is doing and the suggested improvement, and reasoning behind it. nicely answered +1 – datatoo – 2011-08-05T16:17:19.067
Thanks for the help. I'd vote for this but my rep isn't high enough. – Chris Stein – 2011-08-08T14:41:09.823