Please help me to find the zone by using the excel function, i am stuck at which formula to use

Original shipment data

Order Number	Suffix	Invoice Date	Number of Lines	Quantity Shipped	Customer Number	Type	Total Order Value	Total Invoice Value	Ship-to City	Ship-to State	# Digit Zip	Ship-to Zip Code	ShipVia	Actual Freight
7917833	0	39030	10	11	611780	W	465.56	465.56	BROCKTON	MA	023	2302	UPSG	7.28
7917833	1	39031	1	1	611780	W	37.83	37.83	BROCKTON	MA	023	2302	UPSG	3.87
7917833	2	39048	2	2	611780	W	20.28	20.28	BROCKTON	MA	023	2302	UPSG	3.84
7917834	0	39030	1	2	647258	W	9.46	15.62	BROOKLYN	NY	112	11234	UPSG	3.8

The zone given

ZONES
Dest. ZIP	Ground
004-005	003
006-007	045
009	045
010-016	003
017-031	004
032-037	003
038-049	004
050-054	003
055	004
056-083	003
084	004
085-089	003
100-129	003
130-149	002
150-157	003
158	002
159-162	003

177	002
178-183	003
184-188	002
189-217	003
218	004
219-223	003
224-225	004
226	003
227-253	004
254	003
255-259	004
260	003
261-262	004
263-265	003
266	004
267-268	003
270-283	004
284	005
285-288	004
289-296	005
297	004
298-324	005
325	006
326-328	005
329-339	006
341	006
342	006
344	005
346	006
347	005
349	006

a) Please help to find the zone by using excel formula