Hi Everyone.
I wrote a Query that pulls a custom table from my SQL. It pulls product num, month, year, and sales total for each month. Here is a look at the table for one product:
table1.png
I am trying to put that table in to excel so we can have live forecasting for each product. I have it organized by month over 2.5 years.
table2.png
My formula is
"=IF(MATCH(9,sales_20[[MONTH(datescheduledfulfillment)]:[MONTH(datescheduledfulfillment)]],0),LOOKUP($A8,sales_20[[productnum]:[productnum]],sales_20[[count(soitem.qtyOrdered)]:[count(soitem.qtyOrdered)]]),0)"
This formula only returns the value of the product within month 11. Does anyone have a better solution to looking up a value with a constraint in another column?
Thanks!
Bookmarks