I have a worksheet that has Zip codes that needs to be matched with a master
zip code list with assigned names. One worksheet has a column called “Ship
Zip” the other worksheet has two columns that I need to relate to the “Ship
Zip” column, the first is a column “Zip Code” and the second is a column
“Sales Person” the hope is to set a formula in the worksheet with the “Ship
Zip” that would pull both columns from the other worksheet, if not I would
need to pull the column “Sales Person” that provides the exact match of the
zip codes in both worksheets.