+ Reply to Thread
Results 1 to 2 of 2

Named Ranges and INDEX/MATCH

  1. #1
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208

    Named Ranges and INDEX/MATCH

    I am trying to use Index and Match in conjunction with named ranges. The trick is that I need to use Lookup in order to determine which named range to use. For example, here is the formula I need:

    Please Login or Register  to view this content.
    As you can see, I am using 2 named ranges: FR_2004 and FR_2004_Spec. However, in order to determine these named ranges, I am using the following formula, which returns "FR_2004":

    Please Login or Register  to view this content.
    I tried plugging the above into the Index/Match formula, but obviously, it doesn't work. Is there a trick to make this work? I have attached a sample of the file with the table I am using.

    TIA for any help.

    Jason
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    Ok, never mind, I figured it out. I needed to use the Indirect function.

    Thanks anyway.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1