vlookup cut the data

[XxAlixX]

Hi, Mates how you all doing,
I want to ask one solution.

I have 2 different sheets. 1st sheet contains all employer's asset information (700 Employers data). 2nd sheet Is New sheet given by HR with 600 employers and their employee numbers only.
I used vlookup on the 2nd sheet to get all details with the help of the employer number.
My main question is, is there any method I can just cut or delete those employers' information from my 1st sheet using vlookup. So I can track employers who left. (100 employers)
I really apologize for my bad English and stupid explanation from my side. I hope someone will understand my stupid question and will help me to sort out this issue.
Many Thanks every one

 

[etaf]

you could do a vlookup on the 1st sheet and lookup the employee number on the 2nd sheet
Any number that does not exist on 2nd sheet will return N/A
then you can use a filter to display only the N/A and that will give you the 100 emp numbers that are on Sheet1 but not on sheet 2
then you can delete those if needed

 

[XxAlixX]

you could do a vlookup on the 1st sheet and lookup the employee number on the 2nd sheet
Any number that does not exist on 2nd sheet will return N/A
then you can use a filter to display only the N/A and that will give you the 100 emp numbers that are on Sheet1 but not on sheet 2
then you can delete those if needed

Thank you so much for your help.
I just found and used "countif" formula from formatting options.
Thanks again for your answer mate, I really appreciate your support.