You can write the name of the range in a cell (say A1) and change the formula
to:
=VLOOKUP(B5,INDIRECT(A1),3,FALSE)
Changing the value of A1 between your valid names will change the range you
are looking at in the formula.

Hope this helps,
Miguel.

"Duane" wrote:

Hi,

I have a drop down box that refers to named ranges. Depending on the name
that is picked in the drop down, I need to retrieve data from a named range.
The range will change and I need to refer to the new range. The formula I am
using is like this:

=VLOOKUP(B5,range,3,FALSE)

I want to change the "range" to a cell link where the name of the range I
want to use will be....which will change based on user selection.

Hope this makes sense.