Forum Discussion
Kazi Hassan
Nov 15, 2018Copper Contributor
Combining IF and INDEX functions
Hi am trying to find out if I could index match with if the following : matching the invoice from production volume and match it to the delivery date to populate the sales according to the month ...
Detlef_Lewin
Nov 16, 2018Silver Contributor
Hi
You have to change the data into a data set list (unpivot) and then create a Pivot table.