Using Value of a Cell in the Range Reference in VLOOKUP
 

I am trying to use the value of cell to be the reference to a named range in
a VLOOKUP function:

=VLOOKUP(Value,$A$2,A1,false)

in cell A2 would be entered the named range value, i.e., "Data"

I know that I can use references for the lookup and the offset values. Any
ideas? Can I automate VLOOKUP with this much flexibility?

Using Value of a Cell in the Range Reference in VLOOKUP
 

Use the INDIRECT function. Replace...

$A$2

with

INDIRECT($A$2)

Hope this helps!

http://www.xl-central.com

In article ,
Yangtze wrote:

I am trying to use the value of cell to be the reference to a named range in
a VLOOKUP function:

=VLOOKUP(Value,$A$2,A1,false)

in cell A2 would be entered the named range value, i.e., "Data"

I know that I can use references for the lookup and the offset values. Any
ideas? Can I automate VLOOKUP with this much flexibility?