DaveMacdonald
Board Regular
- Joined
- Nov 28, 2013
- Messages
- 52
- Office Version
- 365
- Platform
- Windows
Hello,
I have a roster of employees where A is last name and C is first name. I have a new list of folks that require a certain training that I want to record in AE. Is there a way to check each name in Columns A and C against a new list (columns A and B) and if the first list name is on the second list, to place a "x" in the original lists AE Column? and do to that for the whole table, (2:264)?
Sheet 1
Sheet 2
I have a roster of employees where A is last name and C is first name. I have a new list of folks that require a certain training that I want to record in AE. Is there a way to check each name in Columns A and C against a new list (columns A and B) and if the first list name is on the second list, to place a "x" in the original lists AE Column? and do to that for the whole table, (2:264)?
Sheet 1
A | C | AE |
Smith | Dorothy | x (Formula Here). I've tried =IF(AND(A:A='sheet2'!A:A,C:C='sheet2'!B:B),"x","") but that didnt work. I'm not entirely sure how vlookup/xlookup works but I thought that was my next step. I dont know though. It's got to be a match for both first and last names, theres a lot of folks with the same first or last name on the list. |
Amos | Jack | |
Smith | Harry |
Sheet 2
A | B |
Smith | Dorothy |
Amos | Sandy |
Peach | James |