mattyblueice
Board Regular
- Joined
- Jul 24, 2014
- Messages
- 85
- Office Version
- 365
- Platform
- MacOS
I have a large client product ID grid I am working with where I am trying to develop a formula that will pick up the column header values (product ID) if an X is present in the cell. The formula is in the Codes column, below is a sample of what I am working with but there are many product codes and clients.
I have researching formulas IF, MATCH and INDEX, but I am stuck about how to get this to work? Can anyone offer any suggestions please?
<tbody>
</tbody>
I have researching formulas IF, MATCH and INDEX, but I am stuck about how to get this to work? Can anyone offer any suggestions please?
A | B | C | D | E | F | G | H |
1 | Client | Codes | B12 | B14 | B36 | B45 | B68 |
2 | Smith | B12, B36, B45 | X | X | X | ||
3 | Jones | B14, B36, B45 | X | X | X | ||
4 | Paul | B12, B14, B36, B45, B68 | X | X | X | X | X |
<tbody>
</tbody>