Using Solver & VLOOKUP together
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Using Solver & VLOOKUP together

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi there:

    When using the solver function, is it possible to get the VLOOKUP function to run as part of the solver routine?, i.e. some cells influenced by the solver contain the Vlookup command and when I try to run solver it can't seem to handle it. Then, after a minute or so it comes back with a message to say solution has been found but none of the cells have changed!

    Any thoughts/possible-solutions gratefully accepted!!

    Brendan Barrett

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I had a similar problem when I had vlookup formulas pulling stock prices from another sheet and the solver solving for the best weighted option with a given set of stocks.

    As I recall, you cannot have the vlookup formula in the "influenced" section. You will need to save the vlookup formulas as values, run the solver, and given that the numbers do not change, replace the vlookup formulas. (Hopefully there are not too many of them)

    You may also want to wait for a more informed opinion to be posted.

    Throwing in my 2 cents.
    -Dave

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Use of the VLOOKUP function in a Solver model is problematic. Take a look at http://www.solver.com/tutorial6.htm. Especially, note the paragraphs on... "Mathematical Relationships" and "Nonsmooth optimization problems". In fact, you may want to review this entire Solver tutorial (See http://www.solver.com/tutorial.htm). These are the folks who created Solver!

    [ This Message was edited by: Mark W. on 2002-04-19 07:14 ]

  4. #4
    Board Regular
    Join Date
    Feb 2008
    Location
    Southampton, England
    Posts
    88
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Using Solver & VLOOKUP together

      
    Did anyone ever solve this because I am having the same issue.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com