Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Reference in Vlookup | Excel Discussion (Misc queries) | |||
vlookup table in external worksheet | Excel Discussion (Misc queries) | |||
VLookup to an external Workbook | New Users to Excel | |||
How do I reference external data from a file, file name found in . | Excel Discussion (Misc queries) | |||
How do I use vlookup to point to an external file that changes nam | Excel Worksheet Functions |