Results 1 to 8 of 8

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

Threaded View

  1. #1
    Registered User
    Join Date
    05-07-2012
    Location
    Earth
    MS-Off Ver
    Excel 2010
    Posts
    9

    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.
    Attached Files Attached Files
    Last edited by Mtes; 05-07-2012 at 03:41 AM. Reason: Forgot to attach workbook.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1