I am using a formula to gather info from 4 worksheets in a separate workbook
but same folder and am getting an error of formula too long. Can anyone help
with an alternative formula that will do the same thing.
My formula is as follows:
=IF(ISERROR(VLOOKUP(C8,'C:\Documents and Settings\Owner\My Documents\Makin''
Life Easy\[Family Contributions 2005.xls]Girls Term
1'!$C$4:$T$40,18,0)),0,(VLOOKUP(C8,'C:\Documents and Settings\Owner\My
Documents\Makin'' Life Easy\[Family Contributions 2005.xls]Girls Term
1'!$C$4:$T$40,18,0)))+IF(ISERROR(VLOOKUP(C8,'C:\Do cuments and
Settings\Owner\My Documents\Makin'' Life Easy\[Family Contributions
2005.xls]Girls Term 1 (Pg 2)'!$C$5:$T$40,18,0)),0,(VLOOKUP(C8,'C:\Documents
and Settings\Owner\My Documents\Makin'' Life Easy\[Family Contributions
2005.xls]Girls Term 1 (Pg
2)'!$C$5:$T$40,18,0)))+IF(ISERROR(VLOOKUP(C8,'C:\D ocuments and
Settings\Owner\My Documents\Makin'' Life Easy\[Family Contributions
2005.xls]Boys Term 1'!$C$4:$T$40,18,0)),0,(VLOOKUP(C8,'C:\Documents and
Settings\Owner\My Documents\Makin'' Life Easy\[Family Contributions
2005.xls]Boys Term 1'!$C$4:$T$40,18,0)))+IF(ISERROR(VLOOKUP(C8,'C:\Do cuments
and Settings\Owner\My Documents\Makin'' Life Easy\[Family Contributions
2005.xls]Boys Term 1 (pg 2)'!$C$5:$T$40,18,0)),0,(VLOOKUP(C8,'C:\Documents
and Settings\Owner\My Documents\Makin'' Life Easy\[Family Contributions
2005.xls]Boys Term 1 (pg 2)'!$C$5:$T$40,18,0)))