# 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

#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 Coast2= Mountain3= Central4= East CoastOR 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 BMIKE

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