Hello,

Assuming the data is in A1:E25 (including header)

Enter your required Zip codes in a range, ie: H2 to down, then in

I2; with CTRL+SHIFT+ENTER not just ENTER

=MAX(IF(B$2:B$25=H2,E$2:E$25))

J2; with CTRL+SHIFT+ENTER not just ENTER

=INDEX(A$2:A$25,MATCH(1,IF(B$2:B$25=H2,IF(E$2:E$25=I2,1)),0))

Then after select I2:J2 & copy down.

Hope this helps;