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.
Always difficult to resolve issues if you don't not have the sheet in front of you. Perhaps the attached example sheet will help. If not, upload a sample of your sheet so that I can see how it looks.