Formula Tweaking To Pull Adjacent Column Data?

I have three columns of data laid out like this:

Column A Column B Column C Column D
(blank) Purchase Orders Shipments # Shipment Reference Field
12345 1ZX123 xxOO12346
12346 1ZC345 KJH12347--45
12347 1Z7YYT 0000012345XXX

I'm trying to write a formula for column A that essentially looks at the field in column B, finds the instance of the data anywhere in the entirety of Column D, and when it locates it puts the corresponding field from Column C of that line in the results of column A. So the result above would turn out like this:

Column A Column B Column C Column D
(blank) Purchase Orders Shipments # ShipmentReferenceField
1Z7YYT 12345 1ZX123 xxOO12346
1ZX123 12346 1ZC345 KJH12347--45
1ZC345 12347 1Z7YYT 0000012345XXX

I have the origins of a formula here...but I don't know how to put in the part where i'm retrieving the data from Column C of the same line as the target data.

=INDEX($D$1:$D$100, MATCH(B1,1*LEFT($D$1:$D$100,LEN(B1)),0))