Vlookup to return the highest and lowest value

[Utradeshow]

Hi Guys! I'm trying to determine areas based on an Airport code. Is there a formula that would do a lookup to find the Lowest value in column A and the highest value in column a based on search criteria in D2.

Copy of Air Freight ACI Zip Codes by Airport Code.xlsx
	A	B	C	D	E
1	ZipCode	City	State	Airport	Zone
2	07823	BELVIDERE	NJ	ABE	C
3	07863	OXFORD	NJ	ABE	C
4	07882	WASHINGTON	NJ	ABE	C
5	08804	BLOOMSBURY	NJ	ABE	C
6	08808	BROADWAY	NJ	ABE	C
7	08848	MILFORD	NJ	ABE	C
8	08865	ALPHA	NJ	ABE	B
9	08865	PHILLIPSBURG	NJ	ABE	B
10	08886	STEWARTSVILLE	NJ	ABE	C
11	18011	ALBURTIS	PA	ABE	B
12	18013	ROSETO	PA	ABE	C
13	18013	BANGOR	PA	ABE	C
14	18013	EAST BANGOR	PA	ABE	C
15	18014	BATH	PA	ABE	B
16	18015	BETHLEHEM	PA	ABE	A
17	18016	BETHLEHEM	PA	ABE	A
18	18017	BETHLEHEM	PA	ABE	B
19	18017	BUTZTOWN	PA	ABE	B
20	18017	FREEMANSBURG	PA	ABE	B
21	18018	BETHLEHEM	PA	ABE	A
22	18032	CATASAUQUA	PA	ABE	A
23	18034	CENTER VALLEY	PA	ABE	C
24	18036	COOPERSBURG	PA	ABE	C
25	18037	COPLAY	PA	ABE	B
26	18041	EAST GREENVILLE	PA	ABE	C
27	18042	WEST EASTON	PA	ABE	B
28	18042	WILLIAMS TOWNSHIP	PA	ABE	B
29	18042	EASTON	PA	ABE	B
30	18046	EAST TEXAS	PA	ABE	B
31	18049	EMMAUS	PA	ABE	B
32	18051	FOGELSVILLE	PA	ABE	B
33	18052	WHITEHALL	PA	ABE	B
34	18052	HOKENDAUQUA	PA	ABE	B
35	18055	HELLERTOWN	PA	ABE	B
36	18059	LAURYS STATION	PA	ABE	B
37	18062	MACUNGIE	PA	ABE	B
38	18063	MARTINS CREEK	PA	ABE	B
39	18064	NAZARETH	PA	ABE	B
40	18067	NORTHAMPTON	PA	ABE	B
41	18071	PALMERTON	PA	ABE	C
42	18072	PEN ARGYL	PA	ABE	C
43	18073	PENNSBURG	PA	ABE	C
44	18073	RED HILL	PA	ABE	C
45	18077	RIEGELSVILLE	PA	ABE	C
46	18079	SLATEDALE	PA	ABE	C
47	18080	SLATINGTON	PA	ABE	C
48	18080	EMERALD	PA	ABE	C
49	18083	STOCKERTOWN	PA	ABE	B
50	18085	TATAMY	PA	ABE	B
51	18087	TREXLERTOWN	PA	ABE	B
52	18088	WALNUTPORT	PA	ABE	C
53	18091	WIND GAP	PA	ABE	C
54	18101	ALLENTOWN	PA	ABE	A
55	18102	ALLENTOWN	PA	ABE	A
56	18103	ALLENTOWN	PA	ABE	A
57	18104	ALLENTOWN	PA	ABE	A
58	18105	ALLENTOWN	PA	ABE	A
59	18106	WESCOSVILLE	PA	ABE	B
60	18106	ALLENTOWN	PA	ABE	B
61	18175	ALLENTOWN	PA	ABE	A
62	18195	ALLENTOWN	PA	ABE	A
63	18235	WEISSPORT	PA	ABE	C
64	18235	LEHIGHTON	PA	ABE	C
65	18301	EAST STROUDSBURG	PA	ABE	C
66	18327	DELAWARE WATER GAP	PA	ABE	C
67	18343	MOUNT BETHEL	PA	ABE	C
68	18351	PORTLAND	PA	ABE	C
69	18353	SAYLORSBURG	PA	ABE	C
70	18360	STROUDSBURG	PA	ABE	C
71	18951	QUAKERTOWN	PA	ABE	C
72	19530	KUTZTOWN	PA	ABE	C
73	19539	MERTZTOWN	PA	ABE	C
74	19562	TOPTON	PA	ABE	C
Sheet1

 

[Cubist]

Try:

Book3
	A	B	C	D	E	F	G	H
1	ZipCode	City	State	Airport	Zone
2	7823	BELVIDERE	NJ	ABE	C		Airport	ABE
3	7863	OXFORD	NJ	ABE	C		Highest Zipcode	19562
4	7882	WASHINGTON	NJ	ABE	C		Lowest Zipcode	7823
Sheet2

Cell Formulas
Range	Formula
H3	H3	=MAXIFS(A2:A74,D2:D74,H2)
H4	H4	=MINIFS(A2:A74,D2:D74,H2)

 

[Utradeshow]

Yes sir! That works awesome! Thank you so much