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?