lambertlambertlambert
New Member
- Joined
- Sep 23, 2021
- Messages
- 2
- Office Version
- 2013
- Platform
- Windows
Hi,
I am trying to index the column headers (B1:E1) when they match colour (I3:I8), and have a value greater than 0. I would like to match all valid results and not just the first too please. An example of the results I am after are in J3:J8.
Any help greatly appreciated!
I am trying to index the column headers (B1:E1) when they match colour (I3:I8), and have a value greater than 0. I would like to match all valid results and not just the first too please. An example of the results I am after are in J3:J8.
Any help greatly appreciated!
Book1 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | Pen | Pencil | Crayon | Highlighter | ||||||||
2 | Red | 0 | 8 | 0 | 0 | |||||||
3 | Green | 5 | 0 | 5 | 0 | Red | Pencil | |||||
4 | Blue | 1 | 0 | 0 | 0 | Green | Pen, Crayon | |||||
5 | Orange | 5 | 0 | 0 | 2 | Blue | Pen | |||||
6 | Purple | 1 | 2 | 0 | 0 | Orange | Pen, Highlighter | |||||
7 | Yellow | 0 | 0 | 0 | 1 | Purple | Pen, Pencil | |||||
8 | Yellow | Highlighter | ||||||||||
Sheet2 |