Search,update, and add details on master file

Hi i need a little help from you guys, kindly see attach file to visualize my problem, On my file I have MasterFile and File sheet, on File sheet are the details and it will update the master file based on this details, for example if the "Employee Name" exist on "MasterFile" sheet it will update only the Salary column on "MasterFile" if the employee name not on MasterFile it will add the details on it's respective department as you see the format of MasterFile,I want to achieved this using VBA/MACRO,thank you