Hi people
I'm having a bit of trouble with a formula... I'm not even 100% what to use to attack it properly...
I have a variable date range and am wanting to pull back the total value of a product in that range but i need to look the product up from it's code on the forecast review sheet.
Cell H5 downwards are pulling the correct data but they need to be looking at the code in column F and looking it up in the "Customer forecast data sorted" sheet.
If anyone has any ideas or can see where i'm going wrong I'd really appreciate the help!
Many thanks
Adam
Bookmarks