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:
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":
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
Bookmarks