Excel Lookup Rows on two Worksheets
I have a list of all employees, ‘Master List’, which contains all the data about them (24,000 employees)
I have a list of employees, ‘logged in’, which contains only the employees that logged on the system (4,000 employees)
How can I figure out which employees on the ‘Master List’ are also on the ‘logged in’ (they logged into the system recently)?
I need to work from the ‘Master List’ so the indicator has to be in a new column in the ‘Master List’ sheet
employee-example.xlsx
I have a list of employees, ‘logged in’, which contains only the employees that logged on the system (4,000 employees)
How can I figure out which employees on the ‘Master List’ are also on the ‘logged in’ (they logged into the system recently)?
I need to work from the ‘Master List’ so the indicator has to be in a new column in the ‘Master List’ sheet
employee-example.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER