| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel 2003 - referenceing the active worksheet page in vlookup
I have a wookbook with two sheets, named "Dept20" and sheet2. On sheet2 I
have my raw data; Cell A1 "Dept20", Cell B1 4,500. On sheet Dept20 I want to write a vlookup that can reference the data on sheet2 by relating to the name of the active worksheet rather than typing "Dept20" in the vlookup formula. Any ideas? Thanks Ernst |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| import .CSV file to XP EXcel 2003 worksheet, the seperator is com. | New Users to Excel | |||
| why would page 1 of an excel worksheet print smaller of page 2 if. | Excel Discussion (Misc queries) | |||
| Excel 2003 crashes when I close any worksheet | Excel Discussion (Misc queries) | |||
| using a reference in vlookup with excel 2003 | Excel Worksheet Functions | |||
Threaded Mode
