Hello,
I have this problem. I need solver to go through certain amount of numbers, for example from 1 to 3 (integer). These numbers are tied to INDEX-MATCH function as a lookup value in MATCH. It searches in table array, which consists of 2 rows. In 1st row there are numbers from 1 to 3, and in second any other numbers. INDEX-MATCH function gives respective value depending on lookup, obviously. Now as i mentioned, i need solver to go through these numbers (1 to 3) and then determine under which number objective cell was maximum (result of INDEX-MATCH function).
I made solver model for this, but it can't find feasible solution. I think it is because solver doesn't understand that i need it to go only through certain integer numbers, even though i correctly define constrains for variable cells.
Is there a way to correct this, or maybe use any other tactic?
I tried explaining as best as i could, and for more clarity, I'll attach sample workbook. There are 2 sheets: simple and advanced, which just omits invalid results for lookup value.
Thanks.
Bookmarks