I need a formula that looks across b2:z2 for the number 1 and then
returns the text value of row 1 in the column that the number 1 is
found in.

Any suggestions on the formula?

Thanks.