| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
two table lookup match
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 | ? | |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
two table lookup match
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 | ? | |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
two table lookup match
In table 2 - some territories only have 1 county others have up to 6
counties. This has truly stumped me. I feel like it shouldn't be that difficult.... I just can't think logically i guess. "Pete_UK" wrote: 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 | ? | |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
two table lookup match
Yes, but what is the range of territories? I assume they start in H2,
but how far do they go down? I'd like to give you a formula which directly relates to your sheet, so I need to know how far down your data stretches in Table 2. Pete IntricateFool wrote: In table 2 - some territories only have 1 county others have up to 6 counties. This has truly stumped me. I feel like it shouldn't be that difficult.... I just can't think logically i guess. "Pete_UK" wrote: 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 | ? | |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
two table lookup match
I really appreciate your help....
the H column spans down to row 623 (meaning 600+ territories) the C and D columns span down to row 3088 (C column can contain 50+ of the same county) Thank you! "Pete_UK" wrote: Yes, but what is the range of territories? I assume they start in H2, but how far do they go down? I'd like to give you a formula which directly relates to your sheet, so I need to know how far down your data stretches in Table 2. Pete IntricateFool wrote: In table 2 - some territories only have 1 county others have up to 6 counties. This has truly stumped me. I feel like it shouldn't be that difficult.... I just can't think logically i guess. "Pete_UK" wrote: 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 | ? | |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
two table lookup match
Is there anywhere you would trust a file being posted, so you can see an
example? "Pete_UK" wrote: Yes, but what is the range of territories? I assume they start in H2, but how far do they go down? I'd like to give you a formula which directly relates to your sheet, so I need to know how far down your data stretches in Table 2. Pete IntricateFool wrote: In table 2 - some territories only have 1 county others have up to 6 counties. This has truly stumped me. I feel like it shouldn't be that difficult.... I just can't think logically i guess. "Pete_UK" wrote: 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 | ? | |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
two table lookup match
I downloaded the file you referred to in your earlier posting, but that
only had 3 rows of data, so I imagined it was just a sample. I'll work on that for now and then adjust it to suit your 600+ rows of data. Pete IntricateFool wrote: Is there anywhere you would trust a file being posted, so you can see an example? "Pete_UK" wrote: Yes, but what is the range of territories? I assume they start in H2, but how far do they go down? I'd like to give you a formula which directly relates to your sheet, so I need to know how far down your data stretches in Table 2. Pete IntricateFool wrote: In table 2 - some territories only have 1 county others have up to 6 counties. This has truly stumped me. I feel like it shouldn't be that difficult.... I just can't think logically i guess. "Pete_UK" wrote: 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 | ? | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find first nonblank cell row # in pivot table using MATCH | Excel Worksheet Functions | |||
| Complicated If Then / V Lookup / Match Statement... | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Multiple table lookup | Excel Discussion (Misc queries) | |||
| Lookup then Match and insert value from next column | Excel Worksheet Functions | |||
Hybrid Mode
