Displaying "group" type in cell, based on range

I'm trying to create a column which, when the initials of a staff member are entered in another column - the group which I have assigned to that staff member to is displayed automatically.

Eg.

AW, TM, BJ are Managers
BR, TE, FF, MJ are Developers
TS, KK, LI are Staff

When those initials are added to column A, I'd like column B to populate with their specific group.

I think this is really easy but I can't figure it out!

Many thanks,

A. Walloper

Put this in B2 of Sheet1:

=IFERROR(VLOOKUP(A2,Lookup!$A$2:$B$11,2,0),"")

then copy down as required.

Hope this helps.

Pete

That's it!! Thank you so much Pete!

You're welcome - thanks for the rep.

Pete