Home |
Search |
Today's Posts |
#1
|
|||
|
|||
look up formula
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))) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |