So basically I have a list of zip codes, and i need to setup a way for a zip code to be checked against 4 lists, and if it appears in the list, I need it to return a certain message based on the list that it appears in.
Attached is a sample file to show some of the sample information. The zip code that needs to be checked is column B on Sheet 2. (Dest Zip).
So for example, i need to look for the value of b5 and run it across tab DAS columns B D F and H. IF B5 appears in one of those columns, then I need a message returned on tab Sheet 2, that says the name of the column.
Eventually, based on the column, and other shipping options, a surcharge will be added to the numbers in Column D to then return a new price.
Bookmarks