Find multiple values

Hi,

I have a huge excel sheet (around 4000 entries) and need to find specific, staff in the list (about 1200 unique staff IDs).

I really don't want to have to type in 1200, individual staff IDs in the "Find" tool.

HELP!! What tool can I use to find them all?

Thanks guys

Thanks for your suggestion. Unfortunately, the numbers do not follow a numerical order, so a range won't work, e.g A1:A4000. I have them in a separate list. I'm hoping there's a way I can paste them all into a formula that will find them for me...