Hi, I am not sure how to exactly explain this but I am needing to take an input value and allocate it based on a number of lookup values.

Input Value:  $100

Select Team    

      Based on Team Name lookup, there could be 1 to 10 subvalues to look up.

      Team 1      50% - 45%

      Team 2      25% - 20%

      Team 3      25% - 18%

Calculated Results should be: