How do I use Range Names listed in a VLookup table in a formula?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Essbasedvlpr32 (Essbasedvlpr32_at_discussions.microsoft.com)
Date: 12/15/04 

Date: Wed, 15 Dec 2004 11:31:03 -0800

I currently have set up an array formula using the OFFSET function. As my
reference section in the formula, I want to be able to look up a range name
from a VLookup table based on what a user enters in a specific cell. For
instance, if the text "Gross Losses" corresponds to a range name titled
losses, I want the formula to return the range of cells defined as losses.
The problem is the formula does not recognize losses as the range name, but
only as the text "losses". Therefore the only thing returned in my array is
the text "losses" repeated.
This formula works as desired when I edit the formula and manually type in
the word losses, but I don't want the users to have to do that.

Any ideas?

Relevant Pages