VLOOKUP with Multiple References

Hi,

I'm stuck with my formula. I'm rebuilding an existing formula, but the complexity of the new version has gotten the better of me.

The OLD FORMULA has limitations, such as a single set of assumptions for all years, and different formulas for the first month and the balance of the months. The NEW FORMULA should allow me to have a different set of assumptions for each year (see the "Control" sheet) and a consistent formula for all months (including the first month).

The attached workbook shows a simplified version of my challenge. I also show the old formula - the formula I'm trying to rebuild. If I can solve for the "Sr. Underwriter" row (Row 14), I can adjust that formula for my other needs. Also, as a point of clarification, if I enter any non-zero number in Cell B14, then I get a result for January 2014; however, that's the sort of assumption I'm trying to avoid. I want the formula to refer to the assumptions for the correct year, on the Control sheet (e.g., 2014, 2015, 2016).

A solution would come from someone who has better skills than I have, and I appreciate any help.