Vlookup in VBA for a beginner

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.

Assuming that you have something like JD in column 1 of your named range and John Doe in column 2 of your named range then this Vloohup will work, just paste it in and change the value B2 to suit

Please Login or Register  to view this content.

Regards,
Simon