# Solver Based on Lookup

#### ExcelKid_10

##### Board Regular
hi all-

say I am having some trouble with using the solver based on a look up.

what i have is simply a table is a three column table based on rank (input) that does a look up and pulls in a cost accordingly. I am trying to find the optimal combination of a series with the constraint value being 100. A quick example would be:

Rank Cost Product
1 37 shoes
5 40 pants
7 13 shirts
Total 100

I am really trying to get the highest rank per product without going over my constraint of 100. The only caveat is that the ranks for these are based on each products ranking respective to its product line. Is this possible or am I using the solver wrong.

Thanks!

EK

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

#### Glove_Man

##### Well-known Member
I doubt it's possible becuase solver uses algebraic methods and this is fundamentally a discrete (and hence discontinuous) mathematics problem.

The problem as you've described is also not going to provide a unique solution. For example, if each pair of shoes and each pair of pants costs \$30 then the solutions:

2 shoes, 1 Pants or 1 shoes 2 pants

can't be told apart.

Philip

Replies
1
Views
979
Replies
1
Views
1K
Replies
0
Views
604
Replies
1
Views
383
Replies
4
Views
1K

1,191,122
Messages
5,984,772
Members
439,909
Latest member
daigoku

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back