lookup with sheet name

[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

 

[Bob Phillips]

Just precede it the sheet name

Sheet1!A1

--
HTH

Bob Phillips

"MatthijsBonte" <[email protected]>
wrote in message
news:[email protected]...