Hello,
I have a task I hope someone can help me with. I have two different spreadsheets, one has a list of people currently working in my company. And the other has a list of people that has ever worked at our company, including current and past employees. I somehow want to connect these two spreadsheets so that the result gives me a list of people that does not work there anymore. Would this be possible?
Thank you in advance.
-Mary
Hi Marielle,
You can use VLOOKUP function to get the result in Second Sheet where you have all employees list
Considering Unique value as Emp_Id in Column B in both the sheets
>> Add one helper column in Second sheet and type the below formula in C2 --> (Helper column)
=VLOOKUP(B2,Active!B:B,1,0)
>> Fill down the formula
>>N/A's are those staff who are not available in Active employees list
for your easy reference and understanding i have attached excel sheet
Thank you...
Thank You.....
Thank you so much!! I will try this.
If you got solution then please mark your thread as Solved
And Do not forget to Click * button (Add Reputation Points) from left side
Thank you...
If you got solution then please mark your thread as Solved
And Do not forget to Click * button (Add Reputation Points) from left side
Thank you...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks