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.

Thank you, XOR LX
I tried that input but it unfortunately didn't work. It showed up as N/A.
I can certainly change the numbers-format from Text to Number.
If I do that, would it help shorten the formula?

Thank you, XOR LX!
It worked for me, finally.
I just copied/pasted the attributes first before I did the formula.
Good question about the multiple cell values. I am uncertain as to what to do with it as of yet.
I'd like 2 rows with each Error on their individual rows.
But thank you. I really appreciate your help!

Good morning again, all.
XOR LX, thank you for the recommendation.
However, it gets a little cumbersome doing the formula each time since the rows continue to change.
I'd realllllly prefer putting the error-table on its own tab and a macro to lookup/match.
Is there any way that can be done?