Referring to a range name stored in a cell

  • Thread starter Thread starter Mike Kramer
  • Start date Start date
M

Mike Kramer

I have a spreadsheet, which contains 18 tables. All these
tables have been named with a 3 letter abbreviation, such
as VRN. In these tables I need to perform a lookup
operation with VLOOKUP. To select the right table I
construct the abbreviation of the range name in a cell:

B2: formula which gives value "VRN"
B3: vlookup(3,function(B2),4,0)

I am looking for a function in B3 to refer to the value of
B2 in such a way that the vlookup command recognizes that
this value is a range name. Any help would be most
appreciated.

Cheers,
Mike.
 
Mike Kramer said:
I have a spreadsheet, which contains 18 tables. All these
tables have been named with a 3 letter abbreviation, such
as VRN. In these tables I need to perform a lookup
operation with VLOOKUP. To select the right table I
construct the abbreviation of the range name in a cell:

B2: formula which gives value "VRN"
B3: vlookup(3,function(B2),4,0)

I am looking for a function in B3 to refer to the value of
B2 in such a way that the vlookup command recognizes that
this value is a range name. Any help would be most
appreciated.

Cheers,
Mike.
Click to expand...

The function you are looking for is INDIRECT:
=VLOOKUP(3,INDIRECT(B2),4,0)
 
Paul / Jim,

Thanks. I must have used indirect a thousand times to
refer to cell addresses, but never thought to use it to
refer to a range name.

Thanks,
Mike.
 
Back
Top