Make solver go through certain numbers (used in INDEX-MATCH)

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.

Hi Mtes,

Welcome to the forum.

Please attach a sample workbook. Thanks

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi Mtes,

Refer your attachment.. When I entered 3 in C2.. it fetched 78 in cell A6.. which is maximum number in row 10.. I guess everything is ok.. else explain what value you are looking for?
Do you need the 3 instead of 78 because 3 is having maximum number(78) under it? or what ? Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Okay.. in order to obtain 3, you could use below formula:-

=OFFSET($A$9,0,MATCH(MAX($A$10:$C$10),$A$10:$C$10,0)-1)


Test(9).xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>