Find a list of values within a table, locate & extract matching rows

I'm preparing a large data set of addresses for use in ArcGIS.

I need all addresses in the final list to match one of the valid CA zip codes from my list of valid zip codes.

How can I search for ALL of these zip codes within my data set & identify all rows with matching zips?

I would like to do this and remove any rows with zips that do not match the list.



FYI i have been doing this in a weird roundabout manual way:
Pasting the list of valid zips to the end of the zip code column in my data set, then sorting for duplicates and removing all that are not duplicates.