How can I make a vLookup dynamic?

S

smonczka

I would like to create a vlookup but have the range pulled from
another cell so the range in the vLookup would change based on the
value in the cell. For example =vlookup(A1,B1,2,False) where B1 is a
drop down list of range names in another sheet. So when you changed
the range name in B1 the vlookup would look up a different range.

Is this posible, when I try referencing a cell instead of typing in a
rangename for B1 the fomula errors out.

Thanks for your help.

Steve
 

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

Can I add a formula or function to Vlookup? 1
trouble with (complicated) vlookup searching another workbook 2
vlookup formatting problem 1
Vlookup and return sheet name also 2
vlookup multiple data 11
Dragging a formula down isn't working - where am I going wrong? 1
Index Match, IF or Vlookup 0
How do I insert a dynamic reference of a range inside VLOOKUP? 4

Top