I need your help on  this. I imported data from excel file. One of the filed is Analyst Name, I want to add "Department" based on the name found in "Analyst Name". 

For example: If the analyst name is Mark or Peter or Marie, The Department filed would be "Research", if name is Jubin, Relji,... the Department field would be "IT support".

Thank you