I am trying to create a database that will show me a list of motor specifications based on what we have them labeled as and were that unit is located. The data table looks something like this:
<tbody>
</tbody>
The active table looks something like this:
<tbody>
</tbody>
The idea is you pick a location from the first drop down menu, then a name from the second drop down menu which is dependent on the first drop down menu, returning only the names that are at that location, and finally you are given a value dependent on both A2 and B2, found on the data table. Pumps are named the same at some locations, and some locations have more than one pumps so I cannot use just the one value, I must use both values.
Is there a way to have MATCH (or similar function) return an array instead of a column value? I could then have INDEX search an array defined by MATCH or the other way around?
A | B | C | D | E | F | G | H | I | J | |
1 | Pump Location | Pump Name | HP | Volts | Phase | RPM | Overload | OCPD | ||
2 | Well 1 | Well Pump | 2 | 240 | 3 | 3000 | ||||
3 | Well 2 | Well Pump | 5 | 240 | 3 | 7500 | ||||
4 | Plant 1 | Pump 1 | 10 | 480 | 3 | 1000 | ||||
5 | Plant 1 | Pump 2 | 25 | 480 | 3 | 2500 | ||||
6 | Plant 1 | Pump 3 | 25 | 480 | 3 | 2500 | ||||
7 | Plant 2 | Pump 1 | 50 | 240 | 3 | 5000 | ||||
8 | Plant 2 | Pump 2 | 50 | 240 | 3 | 5000 | ||||
9 | Plant 2 | Pump 3 | 50 | 480 | 3 | 10000 |
<tbody>
</tbody>
The active table looks something like this:
A | B | C | D | E | F | G | H | I | |
1 | Location | Name | HP | Volts | Phase | RPM | |||
2 | Drop Down Menu | Drop Down Menu Dependent on A2 | Value | Value | Value | Value |
<tbody>
</tbody>
The idea is you pick a location from the first drop down menu, then a name from the second drop down menu which is dependent on the first drop down menu, returning only the names that are at that location, and finally you are given a value dependent on both A2 and B2, found on the data table. Pumps are named the same at some locations, and some locations have more than one pumps so I cannot use just the one value, I must use both values.
Is there a way to have MATCH (or similar function) return an array instead of a column value? I could then have INDEX search an array defined by MATCH or the other way around?