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
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