Solver Custom Function with VLOOKUP

[cosh39]

Hi there,

I am also facing a similar problem using solver with VLOOKUP and the evolutionary algorithm. I have programmed a function that reads two ranges,then performs a range to array assignment and some other calculations and spits out the result. The values in the ranges are calculated using vlookups on the variables that solver should change to achieve my target (maximize my objective function).

For anybody willing to help I can send the file in question.

Thank you in advance for your help.