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?

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?

Extending Biff's comments: set up a 2-column table with the states in the
left column & the region in the right, like so:

FL Southeast
CA Southwest
WA Northwest

Name the table Regions

for each row of contacts use a formula like this, assuming state is in
column E

=vlookup(e2,region,2,0)


"sskirvin" wrote:

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?

Duke:

This answer was everything I needed. Thank You. My Regions are based on
County and State in 2 separate columns which means I will assign a region
based on the county and state.

I am going to assume that if I create a table that lists the regions on
another sheet in a workbook, the formula will have to look at both state
column and the county column then lookup the region from the named list.

Thank you for the prompt reply. I will be able to figure it out hopefully.

"Duke Carey" wrote:

Extending Biff's comments: set up a 2-column table with the states in the
left column & the region in the right, like so:

FL Southeast
CA Southwest
WA Northwest

Name the table Regions

for each row of contacts use a formula like this, assuming state is in
column E

=vlookup(e2,region,2,0)


"sskirvin" wrote:

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?