Combining 2 sheets into 1 (vlookup? array?)

[seriousallthetime]

Before we start, I know I can do this via vlookup but it is massively time consuming. You'll see why.

The goal: to figure out when my product will arrive at my assembly centers.

The issue:
I have a spreadsheet from my freight forwarder. It looks like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]PO[/TD]
[TD]SKU[/TD]
[TD]QTY[/TD]
[TD]Depart Date[/TD]
[TD]Destination[/TD]
[TD]Arrival Date[/TD]
[TD]Shipment Status[/TD]
[/TR]
[TR]
[TD][TABLE="width: 638"]
<tbody>[TR]
[TD="width: 638, align: left"]4246607896, 4246618896, 4246619896, 4246620896, 4246621896, 4246627896, 4246629896[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD]1/1/2018[/TD]
[TD]Florida[/TD]
[TD]2/19/18[/TD]
[TD]Awaiting Arrival
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 638"]
<tbody>[TR]
[TD="width: 638, align: left"]4252919896, 4252921896[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD]2/5/2018[/TD]
[TD]Ohio[/TD]
[TD]9/25/18[/TD]
[TD]Awaiting Arrival[/TD]
[/TR]
[TR]
[TD][TABLE="width: 638"]
<tbody>[TR]
[TD="width: 638, align: left"]2008788898, 2008791898, 2008796898, 2008797898[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD]3/5/2018[/TD]
[TD]Washington[/TD]
[TD]12/5/18[/TD]
[TD]Awaiting Arrival[/TD]
[/TR]
</tbody>[/TABLE]


I have a spreadsheet that looks like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]PO[/TD]
[TD]SKU[/TD]
[TD]QTY[/TD]
[/TR]
[TR]
[TD]4246607896[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR]
[TD]212160008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]12
[/TD]
[/TR]
[TR]
[TD]4246618896[/TD]
[TD]212160004[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]4246618896[/TD]
[TD]212160006[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]425919896[/TD]
[TD]212160025[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]425919896[/TD]
[TD]212160024[/TD]
[TD]15
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


How do I combine these two into some kind of coherent document that can tell me when stuff is coming in? Obviously there are a whole lot more POs, several hundred in fact. Way to many to do by hand.

Every PO in the first sheet is represented on the second sheet. Every PO can have one or more SKUs on it, all with different quantities. The first sheet gives me the PO number and all of the inbound timeline data. The second sheet gives me all of the PO content data. I need them on one sheet. How?

 

[mrshl9898]

Assuming the second set of PO's are in column A and the first set of data is on Sheet1:


=INDEX(Sheet1!A:F,MATCH("*"&A2&"*",Sheet1!A:A,0),6)

 

[seriousallthetime]

Assuming the second set of PO's are in column A and the first set of data is on Sheet1:


=INDEX(Sheet1!A:F,MATCH("*"&A2&"*",Sheet1!A:A,0),6)

Thank you! This worked perfectly!