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.