I have several header names that in some instances have duplicate values. I would like to show both header names with duplicate results.
I am using the following formula:
=INDEX($C$4:$O$4,,MATCH(D27,D8:P8,0))
I have attached a copy of the sheet for reference. The result shows ROI however, OEX has also posted the same value. How do I get OEX to populate in the adjacent cell?
Thank you