Vlookup dynamically changes for different ranges

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

Guest

I have a vlookup that needs to look at different tables.

Is there any way to automatically change the range it looks up, without if
lloops. So if you put a 1 in cell A1 it would look up the first range, 2 the
second range and so on. I tried using choose but this did not work.

Thanks
 
You need the INDIRECT() function. Look in HELP for details; if you can't
sort it out, post again!

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
One way (for 1 to 3):

=VLOOKUP(A2,CHOOSE(A1,INDIRECT("sheet1!a1:b999"),
INDIRECT("sheet2!a1:b999"),
INDIRECT("sheet3!A1:b999")),2,FALSE)
(all one cell)
 
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

Dynamic named range reference from external workbook 2
Vlookup - dynamic range reference? 6
totally lost - named range and vlookup 13
Vlookup with an exact match 1
VLOOKUP using a dynamic range 1
Multiple If Stmts 2
vlookup-cell range in formula changes when copied to another cell 2
vlookup range 4

Back
Top