Excel Question #46

Kevy Baby · 02-01-2011, 06:23 PM

Here's another lookup challenge that I am not sure how to handle.

I get USPS and UPS Zone Charts in a format similar to this:

Code:

Zip Code    Zone
  005-212     8
  214-268     8
  270-324     8
  325         7
  326-342     8
  344         8
  346-347     8
  349         8
  350-352     7
  354-359     7
  360-363     8

If some of the Three Digit Zips are shown in a range, is there a way to have Excel look in the range? How would I tell Excel that the Zone for 289 is 8?

02-01-2011, 06:23 PM	#12
Kevy Baby Chowder Head Join Date: Jan 2005 Location: Yes Posts: 18,500	Here's another lookup challenge that I am not sure how to handle. I get USPS and UPS Zone Charts in a format similar to this: Code: Zip Code Zone 005-212 8 214-268 8 270-324 8 325 7 326-342 8 344 8 346-347 8 349 8 350-352 7 354-359 7 360-363 8 If some of the Three Digit Zips are shown in a range, is there a way to have Excel look in the range? How would I tell Excel that the Zone for 289 is 8? __________________ The thing about quotes on the internet is that you cannot verify their validity. - Abraham Lincoln
	Submit to Quotes

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode