scenario testing and stepped table

excel.xlsx

don't know if this could work.
have to go will look at this tommorow.

the formula is array (ctrl+shift+enter)
i based my formula on the output you gave and not tested for other instances of those 1's.
like
1 1 1 1 space space 1 1 1

The problem that i saw is how to move the column-index-numberof the vlookup so i came up with the array formula
=VLOOKUP($J$2,$B$9:$H$10,MATCH(TRUE,LEN(C2:$I2)<>0,0)+SUM($B2:C2),FALSE)*C2

MATCH(TRUE,LEN(C2:$I2)<>0,0) is really the array part(return arrays of {1,1,1,1,1,0}... it find the first value(not blank) in the range C2:$I2.. returning 1 the formula is adjusted when drag from
LEN(C2:$I2) to LEN(D2:$I2)
then we have the +SUM($B2:C2) add the numeric figures so in this part we received again another 1
so

1+1 =2 as our Column-Index-Number....

Try a combo box

with functions maybe like this