Vlookup in external file

[Tami]

i have a vlookup to another file and it works fine....then i have a different
vlookup to the same file, different tab and its coming back as an error
(#value). why is this? i've tried re-writing it several times but basically
the "errro" formula only works if i open the external file...but why don't i
have to do that with the other fornula right next to it, reference the same
file??...uggh...need help.
thx.

 

[Richard Schollar]

Hi

Can you post both formulas you are using - the one that's working and the
one that isn't (and is returning the #VALUE!). Thanks!

Richard

 

[Tami]

not working: adding aug-jan data:
=IF(G7="
",0,VLOOKUP(($A$1&$G7&"aug"),'\\limitedtoo5\too\users\Justice\Plan\MPC\2008\F2008\F2008
Hanging\[D61 Cls
Comp.xls]MPC560'!$A$1:$T$1500,13)+VLOOKUP(($A$1&$G7&"sep"),'\\limitedtoo5\too\users\Justice\Plan\MPC\2008\F2008\F2008
Hanging\[D61 Cls
Comp.xls]MPC560'!$A$1:$T$1500,13)+VLOOKUP(($A$1&$G7&"oct"),'\\limitedtoo5\too\users\Justice\Plan\MPC\2008\F2008\F2008
Hanging\[D61 Cls
Comp.xls]MPC560'!$A$1:$T$1500,13)+VLOOKUP(($A$1&$G7&"nov"),'\\limitedtoo5\too\users\Justice\Plan\MPC\2008\F2008\F2008
Hanging\[D61 Cls
Comp.xls]MPC560'!$A$1:$T$1500,13)+VLOOKUP(($A$1&$G7&"dec"),'\\limitedtoo5\too\users\Justice\Plan\MPC\2008\F2008\F2008
Hanging\[D61 Cls
Comp.xls]MPC560'!$A$1:$T$1500,13)+VLOOKUP(($A$1&$G7&"jan"),'\\limitedtoo5\too\users\Justice\Plan\MPC\2008\F2008\F2008
Hanging\[D61 Cls Comp.xls]MPC560'!$A$1:$T$1500,13))

working: simple v lookup
=IF($G5="
",0,VLOOKUP(($A$1&$G5),'\\limitedtoo5\too\users\Justice\Plan\MPC\2008\F2008\F2008 Hanging\[D61 Cls Comp.xls]MPC460'!$A$1:$P$1500,10))

thanks for any help you can provide.