Hi!

You need to create (if there isn't one already) a table that lists the
regions and their corresponding state/counties.

The you'd use some type of lookup formula.

Can't suggest anything more specific without more details.

Biff

"sskirvin" wrote in message
...
I keep an extensive list of contacts in Excel. The columns a
FirstName, LastName, Address, City, State, Zip, County

In our sales department, they have the States broken up into regions. How
can I have excel automatically assign the region number in my list in it's
own column based on the state and and county columns?

I am trying to avoid having to go through a contact list of 500 or more
and
manually putting in the region number into a column next to the County.

Can anyone help?