Combining IF and INDEX functions

Question

Hi am trying to find out&nbsp; 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&nbsp;&nbsp;&nbsp;Production Volume&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sales&nbsp;&nbsp;&nbsp;&nbsp;InvoiceJan-18Feb-18Mar-18Apr-18Shipping&nbsp;ConsignmentDate Of Delivery&nbsp;&nbsp;Invoice&nbsp;&nbsp;&nbsp;Jan-18Feb-18Mar-18Apr-18INV1525100100300150603001-AprINV1525&nbsp;FALSE&nbsp;&nbsp;&nbsp;INV1526200200200300454501-AprINV1526&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INV1527200300100300303002-MarINV1527&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INV15284004001303000001-JanINV1528&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

detlef_lewin · Answer

Hi&nbsp;You have to change the data into a data set list (unpivot) and then create a Pivot table.&nbsp;

Forum Discussion

Combining IF and INDEX functions

1 Reply

	Production Volume								Sales
Invoice	Jan-18	Feb-18	Mar-18	Apr-18	Shipping	Consignment	Date Of Delivery	Invoice	Jan-18	Feb-18	Mar-18	Apr-18
INV1525	100	100	300	150	60	30	01-Apr	INV1525	FALSE
INV1526	200	200	200	300	45	45	01-Apr	INV1526
INV1527	200	300	100	300	30	30	02-Mar	INV1527
INV1528	400	400	130	300	0	0	01-Jan	INV1528