I am looking for a little help if possible

I have the ability to take a picture of a label that is converted into Xcel in a similar format to below.

COMPANY 1, LLC Guaynabo, Puerto Rico 00969 USA
Assembled in Mexico

Covered by one or more of the following US Patents:
5307976; 5597107; 5662667; 6978921; 7000818; 7044352;
7143923; 7380695; 7380696; 7404508; 7455208; 7490749;
7549564

*+H208EC60A1P*

I LOT | | F4PL96 | Si 2012-09 |

Us* Until Oat*

Us* Until Oat*
00

•♦i2274F4PL06PX*

00235 31764 00



All information is put into one column on sheet 1.
I want to find 3 bits of information in the original sheet, Company Name, Product Code and Lot Number.

I have therefore created:
Sheet 2 with all possibilities for the Company Name
Company 1
Company 2
Company 3 etc

I want the question to go as follows
Does sheet 1 contain the name of any of the companies at all?
If yes I want the company name added to a cell in sheet 3.

Then if so, using a database for all the product codes made by that company in tab “COMPANY 1 Database”
Does Sheet 1 contain a product code from “COMPANY 1 Database”
If yes I want the product code added to a cell in sheet 3
Also the contents of Sheet1A11 (ie the LOT details) into a cell in sheet 3.


The output of this example in sheet 3 should be:

COMPANY 1
EC60A
I LOT | | F4PL96 | Si 2012-09 |


I hope this makes sense

Thanks in advance

Ross