To match the zip codes in the "Ship Zip" column with the master zip code list and retrieve the corresponding sales person, you can use the VLOOKUP function in Microsoft Excel. Here are the steps to follow:

1. Open both worksheets in Excel.
2. Make sure that the zip codes in both worksheets are formatted in the same way (e.g. with or without leading zeros).
3. In the worksheet with the "Ship Zip" column, insert a new column next to it where you will enter the VLOOKUP formula.
4. In the first cell of the new column, enter the following formula:
   Code:

   =VLOOKUP(A2,[Master Zip Code List.xlsx]Sheet1!$A$2:$C$100,3,FALSE)

   - Replace "A2" with the cell reference of the first zip code in the "Ship Zip" column.
   - Replace "Master Zip Code List.xlsx" with the name of the file that contains the master zip code list.
   - Replace "Sheet1" with the name of the worksheet that contains the master zip code list.
   - Replace "$A$2:$C$100" with the range of cells that contains the zip codes and sales persons in the master zip code list. Make sure to include the column with the zip codes as the first column in the range.
   - The "3" in the formula tells Excel to retrieve the value from the third column in the range, which is the column with the sales persons.
   - The "FALSE" in the formula tells Excel to look for an exact match of the zip code in the master zip code list.
5. Copy the formula down to all the cells in the new column that correspond to the zip codes in the "Ship Zip" column.
6. The new column will now display the sales persons that correspond to the zip codes in the "Ship Zip" column. If a zip code in the "Ship Zip" column does not have a match in the master zip code list, the new column will display an error message (#N/A).