lookup with sheet name

M

MatthijsBonte

Hi,

I want to know whether there is a standard function to lookup values in
sheets using the sheet name (i.e. this is different to vlookup())

for example:

column A column B
sheet 1 lookup cell A1 in sheet 1
sheet 2 lookup cell A1 in sheet 2
sheet 3 lookup cell A1 in sheet 3
etc etc..

If it's not a standard function, does anyone have a script for a user
defined function that can do this?

thanks,
Matthijs
 
Top