Excel Formula Help - Match States to Regions

September 21, 2011 at 16:40:10
Specs: Windows 7
I have a column with state abbreviations. I am trying to put a formula in another cell to look at that column, if the state abbreviation is WA, OR, CA or AZ, I want the result to be "West". If it's another range of states, it might return "Central", etc.

Basically trying to tie state names for each customer to Divisions so we can divide up the customer database


See More: Excel Formula Help - Match States to Regions

Report •


#1
September 21, 2011 at 17:13:07
Using a "Helper" column you could associate your states to numbers something like:

      A       B
1)  STATE  Division
1)   WA       1
2)   OR       1
3)   CA       1
4)   AZ       1
5)   NY       4
6)   RI       4
7)   TX       3

1= West Coast
2= Mountain
3= Central
4= East Coast

OR something like:

      A       B
1)  STATE  Division
1)   WA       West
2)   OR       West
3)   CA       West
4)   AZ       West
5)   NY       East
6)   RI       East
7)   TX       Central

How you divide them, is up to you.

Then using a =VLOOKUP() function, just grab the info from column B

MIKE

http://www.skeptic.com/


Report •

#2
September 21, 2011 at 17:32:50
The index of the lookup has to be in order a to z.

Report •

#3
September 21, 2011 at 20:04:18
re: The index of the lookup has to be in order a to z.

Why?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question