Convert Range name in cell for VLookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and return sheet name also 2
Linked Named Ranges 2
Using Value of a Cell in the Range Reference in VLOOKUP 1
Searching the formula (not the value) for a text string 1
convert vlookup formula to link formula 0
How do I insert a dynamic reference of a range inside VLOOKUP? 4
How can I make a vLookup dynamic? 1
Need VLOOKUP to Work Two Ways 0

Back
Top