Jim Metcalf
asked on
I think i need to use vlookup but unsure
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?
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?
VLOOKUP will work between workbooks and will not require the source workbook to actually be open. You must reference the other workbook in the formula. Maybe attach a couple of sample workbooks with private information masked
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you referring to worksheets or different workbooks?
Another alternative would be a PivotTable
Another alternative would be a PivotTable
ASKER
As Mr.Saurabh Singh Teotia,
Suggested
and you done.
Thanks
Suggested
=IF(C2="","",IF(COUNTIF([2.xlsx]Sheet1!$C:$C,C2)>0,"Active","Fired"))
try this (Open Both WB) past this formula in 1.xls cell D2 and formula drop down.and you done.
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks