Hi
VLOOKUP can't work across sheets (also except MS noone will know the
code). Have a look at the morefunc.xll addin (the THREED function):
http://longre.free.fr/english
--
Regards
Frank Kabel
Frankfurt, Germany
"Roy Kirkland" schrieb im Newsbeitrag
...
I am writing an Excel application with considerable VBA in the back
end - I
have been attempting to use data stored on one sheet to supply
variables for
a calculation on another sheet, but have not been able to get Vlookup
to
work across sheets. Is there a workaround for this, or does anyone
know the
code behind the function, and if so, is it possible to write this
code as a
user defined function?
Roy