Here are some of the formulas, ranging from the most simple to complex:
=O10+P10
=U10+V10+W10
=MATCH($BG$2&Amounts!$G10&Amounts!$I10,'Ultimate
Selections'!FactorTypeOutput&'Ultimate
Selections'!CoverageOutput&'Ultimate Selections'!SegmentOutput,0)
=(INDEX('Ultimate
Selections'!$E$6:$BL$101,Amounts!$BD10-1,Amounts!$BG10,1)-INDEX('Ultimate
Selections'!$E$6:$BL$101,Amounts!$BD10-1,Amounts!$BG10+45,1))*($BC10/(INDEX('Ultimate
Selections'!$AX$5:$BL$100,$BD10,$BG10)+(INDEX('Ult imate
Selections'!$AX$5:$BL$100,$BE10,$BG10)+(INDEX('Ult imate
Selections'!$AX$5:$BL$100,$BF10,$BG10)))))*(1/(INDEX('Ultimate
Selections'!$E$6:$BL$101,Amounts!$BD10-1,Amounts!$BG10,1)/INDEX('Ultimate
Selections'!$E$6:$BL$101,Amounts!$BD10-1,Amounts!$BG10+45,1)))+(INDEX('Ultimate
Selections'!$E$6:$BL$101,Amounts!$BD10-1,Amounts!$BG10,1)-INDEX('Ultimate
Selections'!$E$6:$BL$101,Amounts!$BD10-1,Amounts!$BG10+45,1))*($M10/INDEX('Ultimate
Selections'!$AI$5:$AW$100,$BD10,$BG10))*(1-1/(INDEX('Ultimate
Selections'!$E$6:$BL$101,Amounts!$BD10-1,Amounts!$BG10,1)/INDEX('Ultimate
Selections'!$E$6:$BL$101,Amounts!$BD10-1,Amounts!$BG10+45,1)))

The formulas work fine 10, 20, 30 at a time, but I need to apply them
to 30,000 rows.