Determine values of parameters that will give a desired result (Solver?)"

I have an excel file that is essentially a pricing tool. It takes into account multiple variables and uses multiple formulas to determine a price. There are a number of cells with drop down menus to select an option that will produce a value to the right of the drop down menu. For example, there is a drop down menu in cell B27, and it has 3 options to choose from. Each option produces a different value to the cell on the right. Depending on what option you choose, it will put a value in cell C27. There are drop down menus in cells B18, B19, B21, B23, B25, B27, B28, B29, B30, B31, and B32. After you've select an option for all of the different drop down menu cells, it uses this formula: =MIN(MAX(PRODUCT($C$17:$C$33)*'Plan Design _ Options'!B7,1-M20),1+M20) In case you were wondering, the value in B7 on 'Plan Design_Options' is 1.18. The value in cell M20 is .4

The value of =MIN(MAX(PRODUCT($C$17:$C$33)*'Plan Design _ Options'!B7,1-M20),1+M20) is multiplied by 53.07 and than divided by 45%. The value after all of that is than divided by 12 and than divided again by 63%. This gives me my price.

What I am looking to do, is find a way that I can get to a certain price by using any combination of the options in the drop down menus. Is there any automated way of doing this other than randomly picking different options from the drop down menus and hoping I arrive at the price I want? I have looked into using Solver or Scenario Manager but I am not very familiar with either of these two and I struggled to get anything to work. If you have any ideas to help me I would greatly appreciate all your efforts to help me solve this problem. Thank you for reading through this and if you have any questions please feel free to ask.

Moderator's Note: Moved from VBA forum --6SJ