Hi,
Good day!
I'm doing this scenario in Excel:
The Column B2 in the Final Payout sheet would get the value from the Salary sheet Column I18.
The Salary sheet computes the salary of each employee after the user types its name in Salary sheet Column C1.
After the user sees the final payout, Salary sheet I18, the user would manually type it in Final Payout sheet Column B2. Once done with the first one like John, he would now go to the next, manually copying the value from Salary sheet Column I18 to Final Payout sheet columnB2
Is there a way to do this using formula without manually typing the final salary of each employee since it would be in hundreds?
Then it should also write the Tier as well to Column C2 coming from Final Payout H21, H22.
I tried but to no avail. Please help.
Hope you could assist me with this. Thank you in advance.
Bookmarks