Convert Range name in cell for VLookup
 

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.

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.