Link to home
Start Free TrialLog in
Avatar of Wilder1626
Wilder1626Flag for Canada

asked on

Excel formula - Find zone based on postal code ranges

Hi

I have an excel file where i have multiple single postal code in column A. In column B, i want to map them to the zone they correspond.

The way the zone work is based on a postal code range. In column H i will have the FROM value and the column I will be the TO value. In column J will be the zone assigned to the FROM / TO range.

Example:
If in column A, i have the postal code:  "B0J 1T0" and that in my postal code range i have from : "B0J 0A0" to: "B0J 9Z9" assigned to Zone C, in column B it will put zone C as "B0J 1T0" falls between "B0J 0A0" and "B0J 9Z9"

User generated image
How can i put this logic inside a formula?

Thanks for your help
postal-code-range-no1.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Wilder1626

ASKER

just a simple vlookup.!!!  thanks for your help. very simple.