You'll need to use indirect(b1) where data is. I've done this recently at
work, but don't have the format for "data" handy here. Do a search on
queries on this board from "Barb R." and you should find it.

"ddate" wrote in message
...
I wanted to create a vlookup with the range names in a cell so that it
would
be flexible.

Example: current formula: vlookup(A1,data,1,false)

type in cell B1 - data

new formula: vlookup(A1,B1,1,false) .....cannot figure out how to have
the
formula read as value in B1 as a range name instead of a value. Is there
a
formula that can convert it properly?

Thanks.