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