Hi One and All:
I have Employee Status In A1-A25. The Codes used are Active, In Process, Open, Separated.
B1-B25 Contains Emp. IDs.
C1-25 Contains Salary.
Each Pay Period, I get "Active" updates to Salary (C1-C25). These updates go into C1-C25 and are only for those Actively on the payroll.
I initially populated C1-C25 using the new data via a VLookUp. This work great the first time only--then I got rid of the Formulas. Bi-Weekly updates should only impact "Active" IDs since Codes Open, In Process are not hired (No Ids), and Separated never change.
When I run the VLookUp, it updates all Actives salarys as expected, but it also zeros out the other Codes Salaries since those IDs aren't in this bi-weekly Active List.
In a nutshell, I want the Formula to read the VLookUp (actives only)and then, if the Emp ID is not in the LookUp List, disregard and leave whatever Salary was there intact--do not zero it out with #NA or whatever.
Your thoughts!
I have Employee Status In A1-A25. The Codes used are Active, In Process, Open, Separated.
B1-B25 Contains Emp. IDs.
C1-25 Contains Salary.
Each Pay Period, I get "Active" updates to Salary (C1-C25). These updates go into C1-C25 and are only for those Actively on the payroll.
I initially populated C1-C25 using the new data via a VLookUp. This work great the first time only--then I got rid of the Formulas. Bi-Weekly updates should only impact "Active" IDs since Codes Open, In Process are not hired (No Ids), and Separated never change.
When I run the VLookUp, it updates all Actives salarys as expected, but it also zeros out the other Codes Salaries since those IDs aren't in this bi-weekly Active List.
In a nutshell, I want the Formula to read the VLookUp (actives only)and then, if the Emp ID is not in the LookUp List, disregard and leave whatever Salary was there intact--do not zero it out with #NA or whatever.
Your thoughts!