first of all, I don't know how to use vlookup.
I have two spreadsheets. both of them have a column in them for employee id.
one (1) spreadsheet has employee id's that are employed and no longer employed and two (2) spreadsheet has all active employees.
im trying to identify all the employees that are listed in the (1) spreadsheet that are no longer employed by cross referencing it to spreadsheet 2.
how should I go about this?