Home |
Search |
Today's Posts |
#1
|
|||
|
|||
lookup with sheet name
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup values in multipul sheets and show value in another sheet | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Lookup cell contents in on sheet based on a formula in second sheet | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |