Pull data from another file based on certain criterias

[Harley78]

I am trying to figure out how to pull data from from my freight file and have it auto populate in my Balance due Report.

The data from the Freight File that I am wanting to pull are shipment based on "soonest delivery date" that has not yet delivered [column G "Delivered] found on the Freight file, Del Note Qty, Plant ETA and Tracking info and would like them to populate to the Balance due Report file (Column AN, AO and AR) . I believe the common relationship is the PO#, I just don't know how to pull the remaining data, if Column G on the Freight Files shows No and pull the ETA date that will deliver the soonest. I am hoping I explained it well enough, I always have issues with that.

Any input, help would greatly be appreciated. Not even sure if this can be done.

Many thanks

Bill

Balance Due Report

ROW/COLUMN	A	C	AN	AO	AR
	PO#	Part#	Qty in Transit	ETA	Tracking Info
2	5500043424	03730022001	250,000	9/6/2019	Vessel Container Number
3	5500043496	03730616061
4	5500035764	10050625591
5	5500043059	10120405011

Freight File (has all shipments including delivered and from other suppliers)

ROW/COULMN	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
	Part Number	PO.	Vendor	Delivery Note	Del Note Qty.	Invoice#	Delivered	RCVD QTY	Weight kg	Piece Weight	Mode of Transport	Pickup date	Port /Fly Date	Plant ETA	Date Rcvd	Tracking Info
100	0373002201	5500043424	Supplier A	1740873	250,000		YES	250,000	2.830	0.0000	A	8/28/2019		8/30/2019	9/3/2019	FEDEX Tracking Number
135	0373002201	5500035764	Supplier A	1742115	250,000		NO	250,000	2.830	0.0000	S	9/4/2019		9/6/2019	9/6/2019	Vessel Container Number
50	10050625591	5500035764	Supplier B	1743418	250,000		YES	250,000	2.830	0.0000	A	9/11/2019		9/13/2019	9/13/2019	FEDEX 776208235592
62	10050625591	5500035764	Supplier B	1744767	250,000		NO	250,000	2.830	0.0000	S	9/18/2019		9/26/2019	9/26/2019	Vessel Container Number
123	10050625591	5500035764	Supplier B	1751143	250,000		YES	250,000	2.830	0.0000	A	10/23/2019		10/25/2019	10/28/2019	FEDEX 776789120241
1056	10120405011	5500035764	Supplier C	1752454	250,000		YES	250,000	2.830	0.0000	A	11/1/2019		11/5/2019	11/5/2019	FEDEX 776849878576
99	10120405011	5500035764	Supplier E	1754769	250,000		NO	250,000	2.830	0.0000	A	11/13/2019		11/18/2019	11/18/2019	Vessel Container Number
201	10050625591	5500035764	Supplier D	1755930	250,000		NO	250,000	2.830	0.0000	A	11/19/2019		11/21/2019	11/21/2019	Vessel Container Number