Compare 2 lists in 2 spread sheets

Hi All

Spread sheet 1

Contains a column with a list of ID numbers (all are 4 numbers some are 4 numbers with a letter on the end) and colours to go with the ID number in next the column. Approx. 50 lines

Spread sheet 2

This is a spread sheet with multiple columns but have the same 2 has spread sheet 1 - The list in spread sheet can change every time I run the report (Always the same headings)

What I would like is to run spread sheet 2 to get list of data

Then compare the list in in spread sheet 1 to see if any of the data appears in spread sheet 2. if yes then in some way tell me which.

Thank you for reading this