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
  • Last Modified:

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
Asked:
aerick911
1 Solution
 
Patrick MatthewsCommented:
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
 
aerick911Author Commented:
That did the trick, thank you very much!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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