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.