JannetteChristie
Board Regular
- Joined
- Dec 14, 2015
- Messages
- 130
- Office Version
- 365
Hi, hoping someone can help with this.
I have the following sample pump data.
The user will have input 1 of the pump selection categories:
What I am trying to achieve is for the dropdown to be populated with the correct pumps frp,m column 'E' of the pump data.
I have the following sample pump data.
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Control | Pipework Compatability Category | Free Standing | Guiderail | ID Name | ||
20 | M | 2 | 0 | 1 | 1310M-65X.251.V89.230/10 (MC) | ||
21 | M | 2 | 0 | 1 | 1310M-65X.251.V87.230/10 (MC) | ||
22 | M | 2 | 0 | 1 | 1310M-65X.251.V85.230/10 (MC) | ||
23 | M | 2 | 0 | 1 | 1310L-65-80X.451.V84.230/10 (MC) | ||
24 | M | 2 | 0 | 1 | 1310L-65-80X.451.V83.230/10 (MC) | ||
25 | M | 2 | 0 | 1 | 1310L-65-80X.451.V82.230/10 (MC) | ||
39 | M | 2 | 0 | 1 | 1310M-65X.253.V89.400/10 (T) | ||
40 | M | 2 | 0 | 1 | 1310M-65X.253.V87.400/10 (T) | ||
41 | M | 2 | 0 | 1 | 1310M-65X.253.V85.400/10 (T) | ||
42 | M | 2 | 0 | 1 | 1315H-65X.253.V94.400/10 (T) | ||
43 | M | 2 | 0 | 1 | 1315H-65X.253.V93.400/10 (T) | ||
44 | M | 2 | 0 | 1 | 1315H-65X.253.V91.400/10 (T) | ||
45 | M | 2 | 0 | 1 | 1310L-65-80X.453.V82.400/10 (T) | ||
46 | M | 2 | 0 | 1 | 1310L-65-80X.453.V83.400/10 (T) | ||
47 | M | 2 | 0 | 1 | 1310L-65-80X.453.V84.400/10 (T) | ||
48 | M | 2 | 0 | 1 | 1310L-65-80X.453.V81.400/10 (T) | ||
49 | M | 2 | 0 | 1 | 1310L-65-80X.453.V80.400/10 (T) | ||
74 | M | 2 | 0 | 1 | 1310S-65X.251.S64.230/10 (MC) | ||
75 | M | 2 | 0 | 1 | 1310S-65X.251.S62.230/10 (MC) | ||
76 | M | 2 | 0 | 1 | 1310S-65X.251.S60.230/10 (MC) | ||
92 | M | 2 | 0 | 1 | 1310S-65X.253.S64.400/10 (T) | ||
93 | M | 2 | 0 | 1 | 1310S-65X.253.S62.400/10 (T) | ||
94 | M | 2 | 0 | 1 | 1310S-65W.253.S60.400/10 (T) | ||
95 | M | 2 | 0 | 1 | 1315S-65X.253.S63.400/10 (T) | ||
96 | M | 2 | 0 | 1 | 1315S-65X.253.S62.400/10 (T) | ||
97 | M | 2 | 0 | 1 | 1315S-65X.253.S61.400/10 (T) | ||
133 | A | 2 | 0 | 1 | Ama-Porter 601 SE (M) (A) | ||
134 | M | 2 | 0 | 1 | Ama-Porter 601 NE (M) | ||
135 | M | 2 | 0 | 1 | Ama-Porter 601 ND (T) | ||
136 | M | 2 | 0 | 1 | Ama-Porter 601 ND (T) | ||
137 | A | 2 | 0 | 1 | Ama-Porter 602 SE (M) (A) | ||
138 | M | 2 | 0 | 1 | Ama-Porter 602 NE (M) | ||
139 | M | 2 | 0 | 1 | Ama-Porter 602 ND (T) | ||
140 | M | 2 | 0 | 1 | Ama-Porter 602 ND (T) | ||
141 | A | 2 | 0 | 1 | Ama-Porter 603 SE (M) (A) | ||
142 | M | 2 | 0 | 1 | Ama-Porter 603 NE (M) | ||
143 | M | 2 | 0 | 1 | Ama-Porter 603 ND (T) | ||
144 | M | 2 | 0 | 1 | Ama-Porter 603 ND (T) | ||
Pump Data |
The user will have input 1 of the pump selection categories:
Book1 | |||||||
---|---|---|---|---|---|---|---|
B | C | D | E | F | |||
3 | Pump Data Selection | ||||||
4 | Pump Selection Category | Col A - 'Control' | Col B - 'Pipework Cat' | Col C - 'Free Standing' | Col D - 'Guiderail' | ||
5 | A1F | Ignore (return both A and M) | 1 | 1 | Ignore | ||
6 | M1F | M | 1 | 1 | Ignore | ||
7 | A1G | Ignore (return both A and M) | 1 | Ignore | 1 | ||
8 | M1G | M | 1 | Ignore | 1 | ||
9 | A2G | Ignore (return both A and M) | 2 | Ignore | 1 | ||
10 | M2G | M | 2 | Ignore | 1 | ||
11 | M3G | M | 3 | Ignore | 1 | ||
12 | M4G | M | 4 | Ignore | 1 | ||
13 | M5G | M | 5 | Ignore | 1 | ||
14 | |||||||
15 | |||||||
16 | Input Selection Category Example | M2G | |||||
Selection Data |
What I am trying to achieve is for the dropdown to be populated with the correct pumps frp,m column 'E' of the pump data.
Book1 | ||||
---|---|---|---|---|
B | C | |||
17 | Dropdown | 1310S-65X.251.S64.230/10 (MC) | ||
18 | 1310S-65X.251.S62.230/10 (MC) | |||
19 | 1310S-65X.251.S60.230/10 (MC) | |||
20 | 1310S-65X.253.S64.400/10 (T) | |||
21 | 1310S-65X.253.S62.400/10 (T) | |||
22 | 1310S-65W.253.S60.400/10 (T) | |||
23 | 1315S-65X.253.S63.400/10 (T) | |||
24 | 1315S-65X.253.S62.400/10 (T) | |||
25 | 1315S-65X.253.S61.400/10 (T) | |||
26 | Ama-Porter 601 NE (M) | |||
27 | Ama-Porter 601 ND (T) | |||
28 | Ama-Porter 601 ND (T) | |||
29 | Ama-Porter 602 NE (M) | |||
30 | Ama-Porter 602 ND (T) | |||
31 | Ama-Porter 602 ND (T) | |||
32 | Ama-Porter 603 NE (M) | |||
33 | Ama-Porter 603 ND (T) | |||
34 | Ama-Porter 603 ND (T) | |||
Selection Data |