Hi
Is there any formula that can shorten the below while having the same result? As when i need to add one more function into the cell, it stated "formula too long".
IF(ISERROR(INDEX('[Working- Branches-May 2010.xls]Sheet1'!$D$7:$AJ$47,MATCH($A22,'[Working- Branches-May 2010.xls]Sheet1'!$A$7:$A$47,0),MATCH('[Working- Branches-May 2010.xls]Sheet1'!$S$4,'[Working- Branches-May 2010.xls]Sheet1'!$D$4:$AJ$4,0))),0,INDEX('[Working- Branches-May 2010.xls]Sheet1'!$D$7:$AJ$47,MATCH($A22,'[Working- Branches-May 2010.xls]Sheet1'!$A$7:$A$47,0),MATCH('[Working- Branches-May 2010.xls]Sheet1'!$S$4,'[Working- Branches-May 2010.xls]Sheet1'!$D$4:$AJ$4,0)))+IF(ISERROR(INDEX('[Working- Branches-May 2010.xls]Sheet1'!$D$7:$AJ$47,MATCH($A22,'[Working- Branches-May 2010.xls]Sheet1'!$A$7:$A$47,0),MATCH("non licensed branch Total",'[Working- Branches-May 2010.xls]Sheet1'!$D$4:$AJ$4,0))),0,INDEX('[Working- Branches-May 2010.xls]Sheet1'!$D$7:$AJ$47,MATCH($A22,'[Working- Branches-May 2010.xls]Sheet1'!$A$7:$A$47,0),MATCH("non licensed branch Total",'[Working- Branches-May 2010.xls]Sheet1'!$D$4:$AJ$4,0)))
Thanks in advance
Bookmarks