Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
• Status: Solved
• Priority: Medium
• Security: Public
• Views: 1024

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.
0
aerick911
1 Solution

Commented:
I would set up another worksheet, perhaps named Lookup, with states in Col A and territories
in Col B, one row per state.

Then use VLOOKUP to determine the territory back on the original sheet:

=VLOOKUP(K2,Lookup!\$A:\$B,2,FALSE)
0

Author Commented:
That did the trick, thank you very much!
0

Featured Post

Tackle projects and never again get stuck behind a technical roadblock.