How many Territories do you have in Table 2, i.e. how many rows of data
does the match have to apply across? Presumably, you do not always have
6 Counties for each Territory?

Pete

IntricateFool wrote:
I started another question earlier regarding this topic, but i guess I did
not explain it properly. I know it has to be doable....

Ok, so I have 2 tables.

In the first one Column C contains county names, Column D (the column I am
trying to determine) will contain the name of a Territory.

In table 2 - Column H contains the names of Territories and proceeding the
"Territory Name" is all the counties that fall into that specific territory
(columns I-N). Each territory can only contain unique names.

What type of formula would I use to have the cells in Column D (territory)
determine from Column C (county) they fall into. In other words which
territory does the county fall into based on the columns H through I?

Anybody, please please help me....
Below is a really half-arse model. I could send a file, for a better
reference.

C D H I J N
County | Territory | Territory |Cnty1|Cnty2 | Cnty6

Bucks | ? | West | Harris | Palm| Bing
Tern | ? | SW | Cole | Sand| Lowe
Palm | ? | <-This should be "West" Territory
Ford | ? |