How do I group states into regions?

[kellbell]

I need to group a client list into geographical regions, based on state
(I do have the state listed for each client). Example: the states of
MI, OH, IN, and PA are region 1; states KY, TN, AL, GA, FL are region
2; etc. What is the best way to do this in Excel? Thank you!

 

[Chip Pearson]

If would be helpful is you explain in detail just exactly what
you mean by "group" the client list in to regions.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Don Guillett]

An extra column with the group name/number would be helpful. Then, you could
sort/filter based on that. Or a lookup table to create the group name/number
for you.

 

[kellbell]

It would probably be more accurate to say that I need to "assign" a
region number to each client; this region number is pre-established
based on state. I am thinking vloopkup is the way to do this but just
not sure if that is the best way to accomplish this. So my end result
would be a column added to my client list that shows the region number,
based on my list of states and each region they fall into.... for
example, WA, OR, ID, NV, CA are all in region 1, another list of states
is region 2, etc. Thank you!

 

[Don Guillett]

And you could have a vlookup that assigned the region number for you.
=vlookup(d2,sheet2!a2:b52,2,false)
where d2 contains TX and the lookup range is TX 1

 

[kellbell]

I figured out how to use the vlookup function and it worked, THANK YOU!!

 

[Don Guillett]

glad to help