Hello all,
After a bit of googling and searching these forums, I can't quite find an answer to what seems like a pretty simple problem.

I have a list of around 20 companies that belong to either Group A, or Group B. These companies and their groups are listed in Column A (Company) and Column B (Group) on Worksheet B;

Company Name........Company Group
Name 1...................Group A
Name 2...................Group A
Name 3...................Group B
Name 4...................Group A
Name 5...................Group B
etc..........................etc

On Worksheet A, in Column A, company names (that match company names on Worksheet B) are manually entered. I would like Column B to populate with the company's group as defined on Worksheet B, Column B automatically. This is to speed up data entry, so the person entering each company doesn't have to remember, or look up that company's group (A or B).

In short, if I enter "Name 3" in Column A, I would like Column B to automatically populate with the text "Group B" as defined on Worksheet B.

I'm not quite sure where to begin. Company names will be added and removed from time to time, so ideally I would just update Worksheet B and those changes would be reflected on Worksheet A.

Any help would be greatly appreciated.

Thanks.