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
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