Hi,
I have a list of 3 digit ZIP codes that shows the number of days it takes for a package to be delivered. I have a list of 5 digit ZIP codes without number of days for a package to be delivered. I want to take the delivery day data from the 3 digit list and fill in the 5 digit list. For example: 3 digit ZIP code 680 (column A) gets 2 day delivery (column B). I have 5 digit ZIP codes 68001, 68002, 68003, 68004, 68005, 68006 and all of them are the same 2 day delivery. Any ideas on how I would do this?
Thank you!
Bookmarks