Named Range in a Formula

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

All,

I am currently using named range in a Formula.

Is there a way to reference a cell containing the Named
Range rather than typing it in the formula itself.

Foe Example,

Lets say I have a name range in my workbook called
TaxRates. I also have the Text "TaxRates in cell D1"

Current Formula:
Vlookup(A1,TaxRates,2,0)

Ideal Formula:
Vlookup(A1,D1,2,0)

The problem is that I don't always want to use "TaxRates"
as my lookup range. So what I was trying to do was have
the Named range change based on whatever text was in D1.

Any help would be greatly appreciated.
 
Back
Top