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.