I have a shipping zone chart that references a 3 digit zip code but instead of listing each one separately they are referencing groups of zip codes in a range value instead. How can I get a lookup formula to find a number in that range without having to list them out manually??
Zip Ground 2nd Day Next Day
004-005 006 206 106
006-007 045 225 125
009 045 225 125
010-046 006 206 106
I want to lookup 015 within this table.
Zone.jpg
Bookmarks