Hi Jacc!

I liked your mix of solver with the vlookup function and rounding it up by using "Evolutionary" solver.

Is this possible to solve with Solver?
I have no idea i.e. I've been trying to see if I could find a solver setup that makes sense but so far no luck. Let's hope that forum guru shg takes an interest in this thread. If anybody could solve this he is the one!

I find that as a solver problem this is quite fascinating so I have not given up yet, I'm still tinkering with it.

As the OP uses Excel 2010 he could perhaps try to contact the support department at http://www.solver.com/

they may be able to help him.

Alf