How do I use formulas using dynamic names

  • Thread starter Thread starter DannyP
  • Start date Start date
D

DannyP

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?
 
Back
Top