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
Bob StammOperations ManagerAsked:
Who is Participating?
 
NorieVBA ExpertCommented:
Bob

Here's one thing you could try:

1 Add a header in C1 on the 'Master list' sheet, e.g. Logged In.

2 Put this formula in C2 on 'Master list':

=IF(ISERROR(MATCH(A2,'logged in'!A:A,0)),"No", "Yes")

3 Copy the formula down.
1
 
Bob StammOperations ManagerAuthor Commented:
Just what I needed.  Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.