I want to apply this method to 5 cells in a single sheet (B2,B7,B12,B17,B22)

When a two letter code (well somebody's initialls) is enter into any of these cells, I want to lookup the full name from a table in another sheet (called "Names" Range (A1:B200) replacing the two letter code with the full name.

Any help would be much appreciatted.