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 |
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 |
All times are GMT +1. The time now is 08:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com