Pull a column header from a row of numbers

[Greg Kline]

Hello,

I have a row of mostly blanks but with occasional numbers from 1-7. I need a formula to search a row for a number 1 and match then return a text value in the corresponding column. I can't figure this out. Any ideas?

Thanks,

greg

 

[Claus Busch]

Hi Greg,

Am Sun, 20 Apr 2014 18:28:08 -0700 (PDT) schrieb Greg Kline:

I have a row of mostly blanks but with occasional numbers from 1-7. I need a formula to search a row for a number 1 and match then return a text value in the corresponding column. I can't figure this out. Any ideas?

your numbers in A2:Z2 then:

=INDEX(1:1,MATCH(1,A2:Z2,0))


Regards
Claus B.