| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
XL2002 - VLOOKUP with variable Sheet Name
Hi All
I am trying to create a formula to look up data on a sheet that has a variable sheet name. Here's the current formula: =VLOOKUP(E7,'ac1'!A1:D10,3,FALSE) What I need to do is change the 'ac1' to another name based on which sheet the user is looking at. The sheet name could be ac1, ac2, ac3 etc - the number that appears in the sheet name exists in cell A1 on the sheet that the formula is in. I have tried creating the sheet name in cell B1 using ="ac"&A1, and then trying to reference that in the vlookup formula but it doesn't work. Any help gratefully received. Regards Trevor Williams |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How To make a sheet reference Variable (eq: sum(sheet!D2:H2)) | Excel Discussion (Misc queries) | |||
| Semi-hang in XL2002 | Excel Discussion (Misc queries) | |||
| HOW TO COPY XL2000 (XP) MACROS TO XL2002 (XP) | Excel Discussion (Misc queries) | |||
| variable in a link where the variable is the name of the sheet | Excel Worksheet Functions | |||
| Using min and max function XL2002 | Excel Worksheet Functions | |||
Threaded Mode
