Index/Match function

[derivative_x]

Hello!

I'm trying to avoid writing a lengthy If() function for a spreadsheet, and I was wondering if an INDEX( MATCH() ) combination would help here. I also entertained the VLOOKUP() possibility, but that's not doing so well for me

In cell B23 I have a Data Validation drop down with 3 choices: Low Case, Base Case, and High Case.

When I drop the menu down, I want to match each case with each Row Title (in column B) with each month (Row 29 or Row 5)...that was one of the parts I was confused on

So for example, When I select High Case in B23 I want it to be able to pull up the numbers from C19:O19, and if I choose Low case from that same drop down menu it should pull C9:O9

I figure if I was going to incorporate INDEX(MATCH()) in this sheet it would like:

IF(B23="Low Case", INDEX(A5:O20, MATCH(), 0, IF(B23="Base Case",.....


I attached the actual spreadsheet Im working on to this file

Any Suggestions?

Thanks,
dx