JannetteChristie
Board Regular
- Joined
- Dec 14, 2015
- Messages
- 127
- 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 | ||||
