I have a worksheet (worksheet 1) with names of companies in a
column.

There is another work sheet (worksheet 2) with names of companies
and an identification number in another column.

However The names of the same company in the two sheets are not
exact matches. for example

In sheet the company may be called ABC plc while in sheet 2 it may
simply called ABC.

I am looking for VBA code which will look at each cell in worksheet
1 and check if that is contained (or equal) in any of the cells in
the name column in worksheet 2 (i.e has to loop through name column
in worksheet 2 to check) if a match is found it has to pick the
company name and identification number in another worksheet. or if
possible in worksheet i itself.