Just precede it the sheet name

Sheet1!A1

--
HTH

Bob Phillips

"MatthijsBonte"
wrote in message
news:MatthijsBonte.1ra52f_1119866714.534@excelforu m-nospam.com...

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