Looking to extract multiple matches from a list

Since you have Excel 2016. I'd recommend using Get & Transform (PowerQuery) to perform your operation.

1. Load both table to PQ as connection only.

2. Go in to editor and make sure [Zip Code] column is set to Text type.

3. In your Table2, drop the [Zip Code] column.

4. Merge Table1 into table2 using [TRACK] as key column.

5. Add custom column with following (replacing [tract_zip_122016] with actual table name in your workbook).

6. Drop the merged column and change custom column data type to Text.

7. Load to sheet. See Sheet1 of attached for sample result.

Wow, thank you. Never heard of it, but this looks like a powerful tool. Instructions are a bit vague. I keep trying to reverse engineer yours, but keep getting errors after the custom formula is entered.
There a way to possibly get more detailed instructions?

EDIT: Wait... i think I got it.

You can enter the Query Editor in sample file. You can follow each applied step in right hand pane.

Basically, after you merge the tables using Left Outer Join. You'd use below formula construct.

Please Login or Register  to view this content.

Where TableName is actually the column name of the merged column. And ColumnName is the target column of the source table.

You are welcome and thanks for rep

If you are satisfied with the solution, please mark the thread as solved using thread tool found at top of your initial post.