I have a very confusing issue. I would like to create a solver program that will automaticall configure the percents of "Lot 1 and Lot 2" which is depicted in yellow to get the cell in gray to be .15 exactly. The numbers to the left and right are the independent variables. The handwritten equation would be (.17*.33)+(.14*.67)=15 but I want excel to do the math automatically for me and be exact.
The example is an attached file which will help with some descriptions I have put in the question.