orangebloss
Board Regular
- Joined
- Jun 5, 2013
- Messages
- 51
- Office Version
- 365
- Platform
- Windows
I'm trying to look up values based on three criteria - my gut is that this needs to be an array formula but I'm beggared if I can get it to work. My source table looks as follows:
My Results table looks at the source table and returns the values based on the Project and Category specified in other cells
Which should produce the following results
Index Match Match doesn't seem to work (presumably as it's all columns?) Any assistance is much appreciated!!
Essentially if the Category, Project and month (values 1 to 4 etc) all match then return the value
Alternatively is there an alternative way to structure my source table?
Project | Category | 1 | 2 | 3 | 4 | 5 | 6 |
Project A | Category A | 9 | 4 | 3 | 6 | 0 | 2 |
Project A | Category B | 7 | 3 | 2 | 7 | 5 | 6 |
Project B | Category A | 5 | 4 | 3 | 9 | 7 | 8 |
Project B | Category B | 9 | 1 | 8 | 2 | 7 | 3 |
My Results table looks at the source table and returns the values based on the Project and Category specified in other cells
A | B | C | D | E | |
1 | Project B | ||||
2 | Category | 1 | 2 | 3 | 4 |
3 | Category A | ||||
4 | Category B |
Which should produce the following results
A | B | C | D | E | |
1 | Project B | ||||
2 | Category | 1 | 2 | 3 | 4 |
3 | Category A | 5 | 4 | 3 | 9 |
4 | Category B | 9 | 1 | 8 | 2 |
Index Match Match doesn't seem to work (presumably as it's all columns?) Any assistance is much appreciated!!
Essentially if the Category, Project and month (values 1 to 4 etc) all match then return the value
Alternatively is there an alternative way to structure my source table?
Last edited: