Hello:

Quick question please.

I have a workbook with approximately 800 rows of employee data (starting with their ID). The column data includes various numbers and entries. The last six columns of the workbook document the hours for each employee over the past six weeks. Every Wednesday I update the previous weeks' hours (and delete the oldest week), which I pull from two different SAP reporting tools. Now my question. I want to find a more efficient way to determine whether an existing employee left the company AND/OR a new employee was added to the system. The formula I use (below) to pull the hours data in from the two different SAP reports is referencing the employee ID. But the formula only works if it finds an exisisting ID. Rather than sorting out, finding unique values, or manually counting, there must be an easier way to determine whether an employee ID no longer exists in the SAP tool or a new employee was added. Any help would be greatly appreciated. Sincerely, Kyle.


=IFERROR(IF(ISNA(VLOOKUP(F2,Sheet1!$C$11:$F$456,4,0)),VLOOKUP(F2,Sheet2!$B$10:$L$192,11,0),VLOOKUP(F2,Sheet1!$C$11:$F$456,4,0)),"")