I have an Excel workbook with 2 sheets
Sheet1 (prod-sales-history) has a list of few items and a monthly sales number for 2103
Sheet2 (inventory) illustrates the inventory status of these items during the months of 2013
I am trying to write a formula in Sheet1 monthly columns when they are null or they have 0
If null or 0 then check the inventory sheet for the same item for that period
- if the sheet2 column for the same item > 0 then I know this item had stock in that period so I will mark Sheet1.Column = 0
- otherwise if the sheet2 column for the same item is 'NULL' then I will take the average sales for the full year and assign the value in Sheet1.Column
I am unable to figure how can I go about doing this. Please can someone advise?
I probably have not explained it well but I hope someone may understand.