I have a spreadsheet with the following
Column A = Date
Column B = Employee
Column C = Time Used
Column D = Type of Time (Vacation, Sick, Personal)
Column F= Employee
Column G = Allowed Vacation
Column H = Allowed Personal
Column I = Allowed Sick
Column K = Remaining Vacation
Column L = Remaining Personal
Column M = Remaining Sick
I want to create a formula that will look at columns B, C and D to find the employee, time used and the type of time. Then look at Columns F, G, H and I so that it can subtract the totals correctly.
The formulas would be in Columns K, L and M.
Please see the attached sample file.