Forum Discussion
Comparing lists from two sheets?
Hello,
I have an excel workbook. On the first sheet I have a list of about 200 people who are still on our exchange server. On the second sheet I have a list of every user in our company (about 500) in column A and their last login time in column B.
I'd love to have a sheet with just the 200 people who are still on our exchange server and their last login time. Is there a way to do that?
Okay, if you don't want to filter out (i.e. display) only employees in Sheet2 that occur in Sheet1, you can make a similar formula in Sheet1, eg. in B1.
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)
....assuming that column A in sheet2 has the name and B has the last logon date.
7 Replies
In the second sheet, insert a column and do a VLOOKUP of the employee reference in the first sheet. Then filter on cells that display a matching reference in the inserted column. Someting like
=VLOOKUP(B1,Sheet1!A:J,1,FALSE)
.....assuming that "Sheet1" has the employee reference in column A and that the employee reference in the second sheet has the employee reference in column B.
Thanks so much for helping. On sheet 1 in column A I have the users - e.g. Bob Smith (about 200 people - no other columns - just column A). On Sheet 2 in column A I have the user names - e.g. Abe Smith, Anthony Brown... (about 500 people). In column B of sheet 2 I have their last logon date next to their name (column A). I'm hoping to come up with a sheet of just people who are in both sheets and their last login date. Ideally on Sheet 3 I'd have just 200 entries - column A with a person's name and Column B with their logon date.
Okay, if you don't want to filter out (i.e. display) only employees in Sheet2 that occur in Sheet1, you can make a similar formula in Sheet1, eg. in B1.
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)
....assuming that column A in sheet2 has the name and B has the last logon date.
