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?<attachment></attachment>
Thanks
<attachment></attachment>
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?<attachment></attachment>
Thanks
Last edited: