Dropdown list, variable min/max values

Trying to set up a number of dropdown lists with the parameters in the title. Minimum value for the list is obtained from one table, the maximum value is equal to the minimum + a value from another table.

Sample formulae for the min and max values:

=VLOOKUP($B11, INDIRECT($A11), MATCH(E$2, StatHeader, 0), 0)

=VLOOKUP($B11, INDIRECT($A11), MATCH(E$2, StatHeader, 0), 0)+if(not(iserror(match($B11,AugmentList,0))),VLOOKUP($B11,Augments,MATCH(E$2,AugmentHeader,0),0),0)

I'm not sure if this is default behavior, but if possible the list should also default to the minimum value prior to user selection and after any changes that would alter the range used.

Any and all help is greatly appreciated.