Wilder1626
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"
How can i put this logic inside a formula?
Thanks for your help
postal-code-range-no1.xlsx
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"
How can i put this logic inside a formula?
Thanks for your help
postal-code-range-no1.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER