I have a data list with colums- Name, Address, City, Zip codes - not all zipcodes pertain to my service area.

I have a seperate zipcode list that i want to use for filtering, and I want to see records of only those zipcodes.

Using Vlookup function gives me single vaules only. For example, i have 9 records from zipcode 91006, when I use vlookup I only get a single a record with that zipcode.


Please tell me how to filter my data list from another list of zipcodes?