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"
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.