Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup where target worksheet may vary
I have a formula, similar to one below, that I want to use in many workbooks:
=HLOOKUP(TCI_TestCycle,[TestGroups.xls]REGR!Group,5,FALSE) The worksheet REGR however will change. Sometimes it will have other values depending on the workbook in which the formula is used. These worksheets are in a separate workbook. How, instead of the string REGR, can I insert a value from another cell in the workbook? Thanks, -- Nigel Barton |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup source can vary -- how to code? | Excel Programming | |||
Editing the target worksheet | Excel Discussion (Misc queries) | |||
formula to lookup value and return value from cell at left of target | Excel Worksheet Functions | |||
Vary column width and row height in the same worksheet | Excel Discussion (Misc queries) | |||
Trapping Worksheet Target | Excel Programming |