mole999
Well-known Member
- Joined
- Oct 23, 2004
- Messages
- 10,524
- Office Version
- 2019
- 2016
- 2013
- Platform
- Windows
Sure I am doing something fundamentally wrong, trying to match A & B then look up C i.e. 132.25. Can't believe I haven't found the answer. Individually the MATCH work, combining for a single position is eluding me, hence what is currently showing in C1
Excel Workbook | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | 11/07/2019 | NORTH EAST | #N/A | ||
2 | Abstraction | ||||
3 | UseDate | SECTOR | RELIEF_HRS | ||
4 | 08/07/2019 | NORTH EAST | 0 | ||
5 | 08/07/2019 | NORTH WEST | 0 | ||
6 | 09/07/2019 | NORTH WEST | 0 | ||
7 | 10/07/2019 | NORTH EAST | 0 | ||
8 | 10/07/2019 | NORTH WEST | 0 | ||
9 | 10/07/2019 | SOUTH WEST | 0 | ||
10 | 11/07/2019 | NORTH EAST | 132.25 | ||
SQL Test Data |