Hi everyone!
I have a big excel sheet with all the time entries of employees for 2015, with columns like: employee number, employee name, date of the time entry.
I have another excel sheet that contains the rates of employees as of 1 Jan 2015. Thus, based on the employee number I can Vlookup the rate for each entry as of 1 jan 2015 (Lets call this excel sheet v2).
However, during the year there were rate changes. I have another excel sheet with all the rate changes that contains employee number, employee name, date of rate change, new rate. How can I, using this excelsheet, update the sheet v2 so that every time entry is paired with the correct rate?
Thank you in advance for the help. If any questions please let me know.
Bookmarks