Forum Discussion
Comparing lists from two sheets?
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.
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.
Thanks I'm getting close - I'm going to look at it - For some reason I'm getting a lot of N/As . I did a copy of same names in sheet2 and find them in sheet 1 but get an N/A next to them. And for some reasons the ones that did get dates next to them with the vlookup entry have the wrong dates.
