SImple V Lookup

I need a file to be created so that i am able to compare lists of data (up to 20000 rows) against my current stock data to identify which items i currently already stock and which ones i don't.
I have attached an example file.

Columns A and B
This will be the list of items i have extracted from my own system.

Columns D to J
This is the information from the supplier that they have given me. The lookup needs to compare the values in column D to the values in column A

If the two references match then the results need to be displayed in the matches area starting from Column L if there is no match then the results need to be displayed in the unmatched area starting column U

Every cell in column A should be unique data. Any duplicates should be identified in the Duplicate area starting from column AD

Total number of matches should be shown in cell M1
Total number of unmatched should be shown in cell V1

File needs to be set up to be able to deal with up to 20000 rows of data

The data that gets pasted should always be treated as text during the lookup, with the results displayed as text too.