aerick911
asked on
Evaluate excel spreadsheet for state, and assign a text value for Territory.
I'm trying to concoct a formula for excel that evaluates each cell for the state and then display a territory value.
More or less...
IF K2 = "MN", "KS", "WI", "ND", "SD" then "Midwest Territory"
else
"Other Territory"
I figured I would make an array of states on another sheet to show which territories are which and then have the formula look at those lists.
Im not much of an excel syntax expert, and do appreciate the help.
More or less...
IF K2 = "MN", "KS", "WI", "ND", "SD" then "Midwest Territory"
else
"Other Territory"
I figured I would make an array of states on another sheet to show which territories are which and then have the formula look at those lists.
Im not much of an excel syntax expert, and do appreciate the help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER