I don't have any VBA skills but need to combine data from two excel
lists. one list (A) has 7000 records with many fields against each
unique company, the other list (B) has about half this amount of the
same unique companies (all on original list) but 3 additional fields
that I need to import into the main dataset. So basically is it
possible to set up a formulae that says "If company name in data set
B1 = any company name in data set A then import fields B2, B3 B4 into
dataset A against matching company name - without disturbing the other
fields in A.

Any help greatly appreciated as I asked someone to do this manually
and lost much of the data and much time and now well behind.

mibro