Delete Row If Value in Cell does not Exist In Another Worksheet

[batchjb69]

Is there a way of checking if the cell values of column A in sheet 1 are contained in the cell values of column A in sheet 2.
If they are not in column A of sheet 2 then delete the entire row within sheet 1

[JBeaucaire]

Assuming row1 is titles and data starts at row2...

1) Use an empty column to add a MATCH() formula
M2: =ISNUMBER(MATCH(A2, Sheet2!A:A, 0))

2) Copy down the data set

3) Filter column M for only the FALSE rows

4) Delete them

5) Remove the filter and clear the helper column

Please Login or Register  to view this content.

[batchjb69]

Thanks for your help

[JBeaucaire]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.