Evaluate excel spreadsheet for state, and assign a text value for Territory.

Posted on 2007-10-10
Last Modified: 2012-08-13
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"
"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.
Question by:aerick911
    LVL 92

    Accepted Solution

    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:


    Author Comment

    That did the trick, thank you very much!

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
    Outlook Free & Paid Tools
    Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now