User Defined Functions

[Roy Kirkland]

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

 

[Anne Troy]

vlookup works across sheets if you use a named range.
See: http://www.theofficeexperts.com/excel.htm#TheDreadedVlookup

________________________

**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************

 

[Frank Kabel]

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

 

[Frank Kabel]

Hi Anne
looking at this site it explains using VLOOKUP but not across several
sheets. e.g. a range which consists of more than one sheet?

 

[Bob Phillips]

I think you are getting differing items mixed up, it doesn't need named
ranges, that is Data Validation across sheets.

 

[Bob Phillips]

Frank,

Have you been on too many litres?

 

[Frank Kabel]

Bob
think I got the question wrong. Thought the OP wants to use something
like
=VLOOKUP(value,sheet1:sheet3A1:C100,3,0)

But looking at your response and the others the OP maybe wants
something simpler
Frank
P.S.: Litres: Indeed!!