Hello,
I have a list of territory numbers (A Column) and a list of customers (B Column). I would to create a lookup list where I can choose a specific territory number like 650 below. I would like to populate D Colum with only customers begining with "650". I would like this D Column list to change based on the chosen territory number from the drop list for territory.
Is this possible? I am racking my brain and unable to find a solution.
Thanks,
Mike
I have a list of territory numbers (A Column) and a list of customers (B Column). I would to create a lookup list where I can choose a specific territory number like 650 below. I would like to populate D Colum with only customers begining with "650". I would like this D Column list to change based on the chosen territory number from the drop list for territory.
Is this possible? I am racking my brain and unable to find a solution.
Thanks,
Mike
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | TERR | ASCEND CUST | TERR SELECTED | LIST C1 CUSTOMERS ONLY | ||
2 | 610 | 610 Acustomer | 650 | |||
3 | 620 | 610 Bcustomer | ||||
4 | 640 | 610 Ccustomer | ||||
5 | 650 | 620 Acustomer | ||||
6 | 660 | 620 Dcustomer | ||||
7 | 670 | 620 Mcustomer | ||||
8 | 680 | 640 Ccustomer | ||||
9 | 690 | 640 Ecustomer | ||||
10 | 640 Hcustomer | |||||
11 | 650 Fcustomer | |||||
12 | 650 Jcustomer | |||||
13 | 650 Xcustomer | |||||
14 | 660 Ccustomer | |||||
15 | 660 Mcustomer | |||||
16 | 670 Kcustomer | |||||
17 | 670 Ocustomer | |||||
18 | 680 Bcustomer | |||||
19 | 680 Qcustomer | |||||
20 | 690 Ecustomer | |||||
21 | 690 Fcustomer | |||||
22 | 690 Ycustomer | |||||
Sheet3 |