Using Vlookup and Solver

[bigswiss89]

Hello everyone,

So what I'm trying to do is optimize a fantasy football lineup.
I have a tab for each of the following positions: QB, RB, WR, TE, K. Each tab has a column of the player's names, their projected score and their salary cost.
\1

I have another tab with the positions for the lineup: QB, RB, RB, WR, WR, WR, TE, K.
So this is what I'm working with...
\1
Right now the vlookup is pulling the player with the highest projection, but I'll need a different player for each slot. I also have a separate vlookup pulling the player's salary via the max projection.
Pulling the names and salaries like this: =VLOOKUP(MAX(QB!H2:H25),QB!H2:I25,2,0)
Pulling the projections like this: =MAX(QB!A2:A25)
I'm trying to run the solver to max the total projection and keep the total salary < 55200

Any suggestions? I may have not explained this very well, but I'll answer any questions you have.

[Alf]

A limitation of solver is that all values must be on the same sheet for solver to work on therfore data con not be on different tabs.

There are a number of examples in this forum how to setup a solver model. Try a searc for "fantasy football", "fantasy basked" or just "solver" and you may find several suggestions how to set this up.

Uploading the file with your model could also be a good idea.

Alf