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.