Advanced Filtering in Excel 2016

In Column A, I have 7000 rows of unique bore numbers. In Column D, I have 800 rows of bore numbers.(Column B & C contain data relating to Column A). I want to filter the bore numbers in Column A to only include those bore numbers that are in Column D. I have tried to use the advanced filter function in Excel, with my range selected as the 7000 rows in Column A and my criteria range as the 800 rows in Column D but the result just returns all the numbers in Column A. Any help would be appreciated. I’ve included a link to a picture of a sample of my data.