Lookup for Range in formula

[MrFoget]

http://imgur.com/a/Tktba

I have two tabs: "Inputs" and "Master Data". The values in D2:O7 of Master Data are derived from the Inputs tab as a calculation based upon the date of the column above and the corresponding percentage located in the range from Inputs!$C$3:$N$3.

I want that range to be dynamic, based upon the job title in column B in the Master Data tab.
Basically, the job title in D2 of Master Data is "I", therefore the range is correct in the formula. However, I want the range to change in D3 to Inputs!$C$4:$N$4 because the job title in column B is "II".

How do I change my formula to lookup and output a range in this formula?

Please Login or Register  to view this content.

I believe all that I need to modify is the first parameter in the index function. Please let me know if you need me to clarify anything, I''m not sure if I explained everything properly. I'm hoping the pictures will clarify what I'm attempting to do.
Thanks in advance for your help!!

[FDibbins]

Hi, welcome to the forum

What would some expected answers be there?

Will this work for you?
=IFERROR(IFERROR(IF(D$1>=$A2,INDEX(Inputs!$C$3:$N$3,MATCH($B2,Inputs!$A$3:$A$6,0),MATCH("month "&DATEDIF($A2,D$1,"ym")+1,Inputs!$C$2:$N$2,0)),0),Inputs!$N$3)*(VLOOKUP($B2,Inputs!$A$3:$B$6,2,FALSE)/12),"")