Need to create a formula/function that will return a value based on matching rows

I have included part of an Excel sheet I am working on. The actual sheet(s) contain about 4000 rows each.

The first list (Zip Code List) contains columns for "Subcontractor", "Mailed Address", "Zip Code" and has all three columns' values populated.

The second list, starting at Column E contains the same columns, as you can see, but that list is lacking many Zip Codes.

I would like a formula/function that I can put in cell I3, copy down, that will find matches in the "Subcontractor" column in the 2 lists and return the Zip Code in K3.

Any help is greatly appreciated.

Hi,

I could achieve this with the help of a helper column.

See the attached file.

In H3:

Please Login or Register  to view this content.

In I3:

Please Login or Register  to view this content.

- this is an array formula and needs to be confirmed by pressing CTRL+SHIFT+ENTER

In J3:

Please Login or Register  to view this content.

In K3:

Please Login or Register  to view this content.