I am trying to use the result of vlookup and then evaluate the result of another column.
I have the following two tables:
ID Current Employee 12 Yes 13 No
ID In Roster & Current Employee 12 ? 13 ?
To make the check for if the employee is in Roster, I can do a simple Vlookup:
How do I check the two columns simultaneously to get the result of “In Roster & Current Employee”?
I find COUNTIFS easier here: