How can I add a column to a table that indicates whether a field in one table is found in a different table?
Hello,
I have two tables:
1) Includes three columns: Employee Name and Personnel Number
2) A data set that contains unique logins to a system - each unique login is marked by Personnel Number
I am trying to create a table like this:
Employee Name
Logged into the system (yes or no)
Joe
Yes
Sarah
No
Elise
Yes
I would like the second column (Logged into the system) to return a "Yes" if the employee's personnel number shows up in the second data set (i.e. if that employee has logged into the system and their employee number shows up in the login data).
In excel I was using this function: =IF(ISNA(VLOOKUP(G1,A:A,1,0)),"No","Yes")
Where G1 was the employee's personnel number and column A was a list of all the personnel numbers who had logged into the system
