Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDIRECT, relative name as argument
The name (string) of the relative name (e.g "TestName") is written in
Range "A1". TestName itself is a named formula like "= SheetRef!A$3". Purpose is to get always the value in row three of the correspondent column. When I enter "=TestName" in Range "F26" i will get the value of Range "F3". So, and now I'd like to use a formula, where I use the relative name, which is entered in Range "A1", something like =INDIRECT($A$1), but this doesn't work. The idea is to use the values in column "A" for the relative names in the INDIRECT function. Any approach for a solution? Regards Werner |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
if argument? | Excel Discussion (Misc queries) | |||
Trying to use the INDIRECT funtion with a relative Row reference | Excel Discussion (Misc queries) | |||
IF THEN argument | Excel Discussion (Misc queries) | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions |