Need complex look-up help

[CTGoldWing]

I have an open work order file that has these headers:

Start Date Request Date W/O # Lot Number Work Order Description

This is a sample of the data:

07-24-22 07-26-22 1274476 02135014 SG....LA 600L 208902-200E;400L 208899-020;1000L 208894.0200A

In the above example, the column "Work Order Description" has 3 quantity/part number combinations:

Qty Part Number
600L 208902-200E
400L 208899-020
1000L 208894.0200A

Each of the Part numbers uses a specific bottle that the product is packaged in which is listed in a separate file that I want to use as a look-up file.

Excel does not have a "contains" function.

I need to be able to look-up the bottle used in each of the part numbers.

Any ideas how I can do this?

All help is very much appreciated.

[dosydos]

A good start would be to attach a workbook. Please see yellow ribbon at the top for details on how to do this.