Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use formulas using dynamic names
I am trying to create formulas that can calculate the values using a cell
reference to refer to a named range. For example: HLOOKUP(H15,Demand_1,2,FALSE). "Demand_1" is a name i have given to a table of data where the first row is a horizontal list of dates and H15 is the date for which I want a value returned. I have 3 other named ranges structured the same way and I'd like the formula to be dynamic so that instead of writing the formula as I've shown above it references a single cell reference on that sheet which would contain the Name. The purpose would be so that I can quickly switch the calculations between forecasting scenarios. I've tried using the Index, Indirect and Offset functions but can't seem to get them to work. Any suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use formulas using dynamic names
Hi,
Try this =HLOOKUP(H15,indirect(A3),2,FALSE) cell A3 contains the named ranges -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "DannyP" wrote in message ... I am trying to create formulas that can calculate the values using a cell reference to refer to a named range. For example: HLOOKUP(H15,Demand_1,2,FALSE). "Demand_1" is a name i have given to a table of data where the first row is a horizontal list of dates and H15 is the date for which I want a value returned. I have 3 other named ranges structured the same way and I'd like the formula to be dynamic so that instead of writing the formula as I've shown above it references a single cell reference on that sheet which would contain the Name. The purpose would be so that I can quickly switch the calculations between forecasting scenarios. I've tried using the Index, Indirect and Offset functions but can't seem to get them to work. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Worksheet Names | Excel Discussion (Misc queries) | |||
dynamic XY chart names | Excel Discussion (Misc queries) | |||
Dynamic Worksheet Names | Links and Linking in Excel | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
Dynamic Worksheet Names | Excel Worksheet Functions |