All2Cheesy
Board Regular
- Joined
- Mar 4, 2015
- Messages
- 127
Hello all,
I'm trying to find a value in an array using multiple criteria.
Basically, what I would be looking to achieve in the below example would be to search for A2 in E1:E4, where B2 is also greater than G2:G4, and less than H2:H4 and return the answer from F2:F4
This should output Zone 2
<tbody>
</tbody>
Any assistance is greatly appreciated.
I'm trying to find a value in an array using multiple criteria.
Basically, what I would be looking to achieve in the below example would be to search for A2 in E1:E4, where B2 is also greater than G2:G4, and less than H2:H4 and return the answer from F2:F4
This should output Zone 2
A | B | C | D | E | F | G | H | |
1 | Company | Postcode | Comapny | Zone | Postcode Range 1 | Postcode Range 2 | ||
2 | Test123 | 3015 | Test123 | Zone 1 | 3000 | 3010 | ||
3 | Test123 | Zone 2 | 3011 | 3020 | ||||
4 | Test234 | Zone 1 | 4000 | 4030 |
<tbody>
</tbody>
Any assistance is greatly appreciated.