Hi;

I have an Excel file with a list of prospects, say car salesmen

I have another list with a list of zip codes I wish to target.

How do I use the list of zip codes (in a separate file) to go through the list of records in the prospect file and delete all the entries without a matching zip code?

I'm an Excel novice and the only way I can think of is copying over the target zip codes to the first file and running conditional formatting. A more ideal solution would just Hide or Delete the non-matching records (to save me the time of having to manually delete or hide records)

Thanks!