Convert Range name in cell for VLookup

D

ddate

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.
 
B

Barb Reinhardt

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.
 
Top