J
JerseyJR
I am trying to create a VLOOKUP formula that will allow translating a
customer zip code to a sales rep territory based on a zip code range
table. How can I have the formula compare whether the zip code in the
customer address record is within a zip code range where Column A
contains the Low Zip Code (or beginning range) and Column B contains
the High Zip Code (or ending range)? Below is an example of the table
setup.
Low Zip Code High Zip Code Rep
10001 12001 John Doe
Customer's zip code is 11005
customer zip code to a sales rep territory based on a zip code range
table. How can I have the formula compare whether the zip code in the
customer address record is within a zip code range where Column A
contains the Low Zip Code (or beginning range) and Column B contains
the High Zip Code (or ending range)? Below is an example of the table
setup.
Low Zip Code High Zip Code Rep
10001 12001 John Doe
Customer's zip code is 11005