Referring to a range name stored in a cell

Giganews Newsgroups
Subject: Referring to a range name stored in a cell
Posted by:  Mike Kramer (mike.fm.kram…@pdo.co.om)
Date: Mon, 27 Oct 2003

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.

Replies