Vlookup in external file
 

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.

Vlookup in external file
 

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" wrote in message
...
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.

Vlookup in external file
 

not working: adding aug-jan data:
=IF(G7="
",0,VLOOKUP(($A$1&$G7&"aug"),'\\limitedtoo5\too\us ers\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\F20 08\F2008
Hanging\[D61 Cls
Comp.xls]MPC560'!$A$1:$T$1500,13)+VLOOKUP(($A$1&$G7&"oct"), '\\limitedtoo5\too\users\Justice\Plan\MPC\2008\F20 08\F2008
Hanging\[D61 Cls
Comp.xls]MPC560'!$A$1:$T$1500,13)+VLOOKUP(($A$1&$G7&"nov"), '\\limitedtoo5\too\users\Justice\Plan\MPC\2008\F20 08\F2008
Hanging\[D61 Cls
Comp.xls]MPC560'!$A$1:$T$1500,13)+VLOOKUP(($A$1&$G7&"dec"), '\\limitedtoo5\too\users\Justice\Plan\MPC\2008\F20 08\F2008
Hanging\[D61 Cls
Comp.xls]MPC560'!$A$1:$T$1500,13)+VLOOKUP(($A$1&$G7&"jan"), '\\limitedtoo5\too\users\Justice\Plan\MPC\2008\F20 08\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\Ju stice\Plan\MPC\2008\F2008\F2008 Hanging\[D61 Cls Comp.xls]MPC460'!$A$1:$P$1500,10))

thanks for any help you can provide.

"Richard Schollar" wrote:

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" wrote in message
...
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.