I'm trying to get a column with the total number of cars received based:
From source 1 and Source 2
IF Date Sold + PO + Class + Item and return the total cars received on the same date as PO Sold + Class + Item
Source 1: (Sales Tab in Excel)
Unique ID | PO | Date Sold | Class | Item | Cars Sold |
1 | 11 | 1-Oct | GM | Sierra | 3 |
2 | 22 | 2-Oct | GM | Envoy | 1 |
3 | 33 | 3-Oct | Ford | Mustang | 1 |
4 | 44 | 4-Oct | Ford | Mustang | 5 |
5 | 55 | 5-Oct | Chevy | Silverado | 10 |
6 | 66 | 6-Oct | Chevy | Tahoe | 1 |
Source 2: (Orders Tab on Excel)
PO | Date Received | Class | Item | Cars Received |
11 | 1-Aug | GM | Sierra | 75 |
77 | 1-Aug | GM | Sierra | 75 |
22 | 2-Aug | GM | Envoy | 88 |
88 | 2-Aug | GM | Envoy | 88 |
33 | 3-Aug | Ford | Mustang | 100 |
99 | 3-Aug | Ford | Mustang | 100 |
44 | 4-Aug | Ford | Mustang | 50 |
55 | 5-Aug | Chevy | Silverado | 60 |
66 | 6-Aug | Chevy | Tahoe | 10 |
What i want my final result to be: (Final tab in Excel)
Unique ID | PO | Date Sold | Class | Item | Cars Sold | Date Received | Cars Received |
1 | 11 | 1-Oct | GM | Sierra | 3 | 1-Aug | 150 |
2 | 22 | 2-Oct | GM | Envoy | 1 | 2-Aug | 176 |
3 | 33 | 3-Oct | Ford | Mustang | 1 | 3-Aug | 200 |
4 | 44 | 4-Oct | Ford | Mustang | 5 | 4-Aug | 50 |
5 | 55 | 5-Oct | Chevy | Silverado | 10 | 5-Aug | 60 |
6 | 66 | 6-Oct | Chevy | Tahoe | 1 | 6-Aug | 10 |
Solved! Go to Solution.
Hey @Nickvv
Here is how I approached this problem. It works for the sample dataset that you provided. Hopefully this helps with your entire dataset, too!