Compare 2 sheets and remove the rows that dont have match

I have;
SHEET1 with A,B,C,D,E columns of data (runs to 1000 rows)
SHEET2 with data in column A. (Row length varies. For example sake let it be 200 rows)

Column A data in SHEET2 has values (numbers) that match the data in Column E of SHEET1.

I want a formula so that at the end the result has to be, SHEET1 should only contain rows which has exact the matching value in Column A of SHEET2.

Can you please help me with your expertise.

The excel file on which I want to use the formula is attached.

Hi,
I have attached sheet. You have results in sheet 3 as sheet1 cannot have results and input both. But you can try same formula in sheet1 and filter the blanks and delete those rows.

Damodar said:

Hi,
I have attached sheet. You have results in sheet 3 as sheet1 cannot have results and input both. But you can try same formula in sheet1 and filter the blanks and delete those rows.

Click to expand...

Your help made my life easy. May my Lord bless you Damodar. Thanks alot.

jiijjuu said:

Your help made my life easy. May my Lord bless you Damodar. Thanks alot.

Click to expand...

Happy to help.

Regards,
Damodar