I have a vlookup formula finding the hourly wage for an employee entered. If the employee gets a raise I need to be able to keep the previous hourly rate with data previously entered but show the new rate with new entries.
I have a vlookup formula finding the hourly wage for an employee entered. If the employee gets a raise I need to be able to keep the previous hourly rate with data previously entered but show the new rate with new entries.
OK. How about a sample workbook?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Attached. So if I give Jeff a raise today to $16 per hour and I type 16 into cell L12 (vlookup data) the entry for 4/7/2019 row 10 will calculate the new raise when I want it to keep the previous pay rate for the pay period.
I am thinking there needs to be an IF-Function with <> a certain date.
If I'm understanding what you want correctly, you'd need to keep an hourly rate history for each employee, with the dates the hourly rates went into effect.
If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.
If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.
The data is entered into a table with many more columns of then what is shown in the sample. Is it possible to have the vlookup incorporated with another formula to read the date and only apply the wage if the entered data is >date of raise?
What would be the best way to accomplish your suggestion?
You would need to add an effective date column to your hourly rate table, and keep track of each employee's rate and the date it went into effect. Assuming that effective date would be in column M, you could use this formula, entered as an array formula with ctrl+shift+enter:
This checks to make sure the names match, and looks for the largest hourly rate that is effective before the pay date. Example file attached. Would that work for what you need?Please Login or Register to view this content.
That is exactly what I needed. Thank you very much! I was caught up trying to use a vlookup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks