Hi,

Your email looks not complete.
In my first reply you see the upperleft corner of a sheet.
Format column A as text.
Fill is the zipcodes.
Fill column B with the zones

Fill column D with the zipcoes you want indicated
Fill column E with my formula.

Greetings

Executor