Mattyastill
New Member
- Joined
- Nov 27, 2017
- Messages
- 23
Hi,
I'm trying to find a way which i can return the column headers where a value exists in the cells F:M for the same row. As you can see from the screenshot for the first row, i would like to search for any value in row 3 and bring back the column heads for the rows. I have shown in Column N of what i would like to return if there is a value there.
I have tried a combination of Index, Match Index, Max and Index, Sum-product but just cant seem to get it working.
Any help would be much appreciated
Thanks,
Matthew
I'm trying to find a way which i can return the column headers where a value exists in the cells F:M for the same row. As you can see from the screenshot for the first row, i would like to search for any value in row 3 and bring back the column heads for the rows. I have shown in Column N of what i would like to return if there is a value there.
I have tried a combination of Index, Match Index, Max and Index, Sum-product but just cant seem to get it working.
Any help would be much appreciated
Thanks,
Matthew