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.
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.