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?