Spreadsheet: 856973d1706103628-how-to-create-a-drop-down-list-dependent-on-and-appended-by-multiple-drop-down-lists-test_sample
Sheet: Common Instruments

GS1 |  |  |  | GS2 |  |  |  | GS3 |  |  |  | Venturi Cart 1 |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Water Cart 1 |  |  |  | Water Cart 2 |  |  |  | Water Cart 3
Item | Make | Model | SN | Item | Make | Model | SN | Item | Make | Model | SN | Item | Make | Model | SN | Item | Make | Model | SN | Item | Make | Model | SN | Item | Make | Model | SN | Item | Make | Model | SN | Item | Make | Model | SN
TURBO A P1B | Omega | PX409-2.5CDI | 429082 | [NAME] (CDSP) | Endress & Hauser | PMC51 | JA012D15128 | [NAME] (CDSP) | Endress & Hauser | PMC51-AA21JD1PGJRKJA | E5001815128 | P1A | Endress & Hauser | PMC51-1LD9/156 | JA013115128 | P1A | Endress & Hauser | PMC51-1LD9/156 | E5001B15128 | P1A |  |  |  | PRESS |  |  |  | PRESS |  |  |  | PRESS
TURBO A DP | Omega | PX409-2.5CDI | I11360022 | P3 (TISP) | Endress & Hauser | PMC51 | JA012C15128 | P3 (TISP) | Endress & Hauser | PMC51-AA21JD1PGJRKJA | E5001915128 | DP | Endress & Hauser | PMD55-2EP7/160 | H5000515121 | DP | Endress & Hauser | PMD55-2EP7/160 | JA006215121 | DP |  |  |  | FLOW |  |  |  | FLOW |  |  |  | FLOW
TURBO A BKT | Endress+Hauser | PMC51 | EC01F301052 | P4 (TDSP) | Endress & Hauser | PMC51 | JA012F15128 | P4 (TDSP) | Endress & Hauser | PMC51 | E5001515128 | P1B | Endress & Hauser | PMC51-1LD9/156 | JA013015128 | P1B | Endress & Hauser | PMC51-1LD9/156 | E5001A15128 | P1B
TURBO A P2 | Endress+Hauser | PMC51 | EC01EF01052 | OIL SUP P | Prosense | PTD25-20-0100H | PT056 | OIL SUP P | Prosense | PTD25-20-0100H | PT084
TURBO A P3 | Endress+Hauser | PMC51 | EC01F001052 | OIL FLOW | Endress & Hauser | 83F15 | J7145602000 | OIL FLOW | Endress & Hauser | 83F15 | J7145602000
TURBO A P4 | Endress+Hauser | PMC51 | EC01E501052 | BAROMETER | Endress & Hauser | PMC51 | [NAME] | BAROMETER | Endress & Hauser | PMC51-AA21JD2KGJRKJA | E5002915128
TURBO A OIL P | Prosense | PTD25-20-0100H | PT058 | TURBINE AIRFLOW | Endress & Hauser | Promass 83F80 | H4073516000 | TURBINE AIRFLOW | Endress & Hauser | 83F80 | F4019D16000
TURBO A OIL F | Proteus | 0806SN9 | 262054 | TURBINE FUELFLOW | Endress & Hauser | Promass 83F80 | JA0B9416000 | TURBINE FUELFLOW | Endress & Hauser | 83F08-AAASAAAABABJ | JA0B9416000
TURBO B P1B | Omega | PX409-2.5CDI | 425354
TURBO B DP | Omega | PX409-2.5CDI | I11330007
TURBO B BKT | Endress+Hauser | PMC51 | EC01F301052
TURBO B P2 | Endress+Hauser | PMC51 | EC01ED01052
TURBO B P3 | Endress+Hauser | PMC51 | [NAME]
TURBO B P4 | Endress+Hauser | PMC51 | EC01F201052
TURBO B OIL P | Prosense | PTD25-20-0100H | [NAME]
TURBO B OIL F | Proteus | 0806SN9 | 262053
BAROMETER | Endress+Hauser | PMC51 | E9146701052
Fixed Cells | [NAME] | Water Carts
GS1
GS2
GS3 |  |  |  |  |  | Active Test Cell |  | GS1 | Active Item | TURBO A DP
GS4 |  |  |  |  |  | Active Venturi Cart |  | Venturi Cart 1
GS5 |  |  |  |  |  | Active Water Cart |  | Water Cart 1
GS7
Other
 | ItemList
 | TURBO A DP
 | TURBO A BKT
 | TURBO A P2
 | TURBO A P3
 | TURBO A P4
 | TURBO A OIL P
 | TURBO A OIL F
 | TURBO B P1B
 | TURBO B DP
 | TURBO B BKT
 | TURBO B P2
 | TURBO B P3
 | TURBO B P4
 | TURBO B OIL P
 | TURBO B OIL F
 | BAROMETER
 | P1A
 | DP
 | P1B
 | PRESS
 | FLOW