I am working with excel alot on my new job, I am looking to see if there are any good methods to take a list of data and find it in a larger sheet.

Detailed example:

I have a spread sheet that has 100s of rows of data in several columns
One column is a list of Product IDs, recently i was giving a list of IDs that had to have another set of data updated (a second set of IDs) This is all from random ranges, I want to be able to take a list, put it into a sheet, and use that to search/filter only those. This seems rather simple but Search only lets you find 1 cell at a time, and the text filters is restrictive as well, The advanced filter I thought would work but I dont think I did it right because it wasn't displaying anything

Can anyone give a more detailed adv filter walkthru or another method?

Thanks