Insert data based on match

[Guest]

i need to search for an occurence and when found insert a comment in the next
column. i.e.
So when EW is found in column A the letters EW will be written into Column B
Col A Col B
Int EW
Med EW
Adv BC
Any hints or help would be gratefully appreciated

 

[BrianB]

would a lookup table and using VLOOKUP() function be any good