russelluno123
New Member
- Joined
- Nov 15, 2018
- Messages
- 4
Hi
i was wondering if i could use index match with IF to find the production volume by matching the delivery date and post it to the relavant month in sales
<colgroup><col><col><col><col><col><col><col><col><col><col span="5"></colgroup><tbody>
</tbody>
i was wondering if i could use index match with IF to find the production volume by matching the delivery date and post it to the relavant month in sales
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 |
<colgroup><col><col><col><col><col><col><col><col><col><col span="5"></colgroup><tbody>
</tbody>