I am facing a problem making a table which contains the usage values of certain articles in Excel 2007. The table should show the monthly usage twelve months in history of a insertable value, for instance December, which I have inserted using =TEXT(O2;"00")&"-"&03. This first part works fine.
The values in the table should be based on two conditions: the month (in the row above, given as e.g. "12-2012") and the article code (in the first column, given as e.g. 2365721). The monthly usage numbers are located in another worksheet. I currently use:
=IF(AND(04='Forecast '!2:2;A5='Forecast'!A:A);'Forecast'!W1;0)) which always gives the value 0.
I have tried various formulas, such as VLOOKUP, but non seem to work properly. Note that the it has to be able to change the insertable value, such that when the forecast for next month is made, Januari can be inserted and the values up to 12 months back are given. And as such any month in the past few years.
Your help will be much appriciated!
The values in the table should be based on two conditions: the month (in the row above, given as e.g. "12-2012") and the article code (in the first column, given as e.g. 2365721). The monthly usage numbers are located in another worksheet. I currently use:
=IF(AND(04='Forecast '!2:2;A5='Forecast'!A:A);'Forecast'!W1;0)) which always gives the value 0.
I have tried various formulas, such as VLOOKUP, but non seem to work properly. Note that the it has to be able to change the insertable value, such that when the forecast for next month is made, Januari can be inserted and the values up to 12 months back are given. And as such any month in the past few years.
Your help will be much appriciated!
