lookup_value in For-loop not updating

In the For-loop below the lookup_value in the Vlookup formulas are not updating. That is, the values of Forecast, wForecast and wDemand do not change after subsequent iterations of (i).

I have a msgbox to debug and see what ForecastYear is at the beginning of each iteration of the For-loop. It updates normally from 2016.1 through to 2016.4

Then, I tried copying out the code 4 times, removing the For-Loop completely, and changed the ForecastYear manually in each instance. It works perfectly.

So I can fall back on that, but it still doesn't explain the problem with the vlookups not recognizing the change in the variable.

Thank you for any help on the matter.

Please Login or Register  to view this content.

Would be better if you can upload the workbook so we can look and debug your problem

ok give me the process of what your issue is. I open the userform and I am stuck in a loop asking for product code?

Give this a try. If the returned results are wrong change the columns highlighted in Red.

Please Login or Register  to view this content.

Thanks for the Rep, Please mark the thread as solved.