Return Column Header for Cell Range that equals "1"

Good Morning All,

I've tried numerous Index, VLOOKUP, MATCH, HLOOKUP functions to try and make this work. UNfortunately, I can't.

If there is a macro, that'd be awesome.

The problem I'm having is that I'd like to have a column header be returned for rows of data by looking at a particular cell range and only return the column header that contains the value "1".

I've attached a file to show you my dilemma.

Any help would be greatly appreciated.