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
--
MatthijsBonte
------------------------------------------------------------------------
MatthijsBonte's Profile:
http://www.excelforum.com/member.php...o&userid=24667
View this thread:
http://www.excelforum.com/showthread...hreadid=382415