VLOOKUP formula with a dynamic table_array range

**mmogharreban** · 03-28-2013, 02:24 PM

Hello all,

I am not sure if this is possible, but I am trying to create a vlookup formula where I can define the table_array using a value from another cell. For example: A1="Range 1" I would then like the formula in B1 to read =VLOOKUP(1,"Range 1",2,False). If A1="Range 2", the formula in B1 reads
=VLOOKUP(1,"Range 2",2,False) and so on.

Any suggestions would be greatly appreciated! Thanks!

**Tony Valko** · 03-28-2013, 02:42 PM

Try it like this...

=VLOOKUP(1,INDIRECT(A1),2,0)

Note that this will not work if Range 1 is defined using functions like OFFSET.

If you have problems implementing this tell us the actual address of Range 1.