Named Ranges

[Orbit]

So here is what I am trying to do. I have a drop down list that has a bunch of names. The names are Q3_2011, Q4_2011, Q1_2012, Q2_2012, Q3_2012, Q4_2012, Q1_2013, Q2_2013, Q3_2013, Q4_2013, Q1_2014, Q2_2014, Q3_2014, Q4_2014, Q1_2015, Q2_2015, Q3_2015, Q4_2015.

I created two named ranges for each of the above, Ex.: Q3_2011_1 and Q3_2011_2.

These will be used in an index match match formula that I have already completed.

What I want to be able to do is change the drop down to Q3_2011, and have the sections of the formula update to Q3_2011_1 and Q3_2011_2.

I just don't know what to put into the formula to get this to work.

Something like (assuming the drop down is in B4): =B4&"_1" just displays Q3_2011_1 as a sting not as a named range.

Any help is much appreciated.

 

[Orbit]

Unfortunately I can't share the work book. It contains confidential information that I am unable to share.

 

[L. Howard]

Perhaps you can dummy down an example sheet/sheets by doing a sheet wide find > replace a, e, i, o, u with x and 2, 4, 6 with 1.

Should muddle the info to non-readable and retain the gist of the sheet enough to ponder the formulas.

Just a thought.

Howard