Pull a column header from a row of numbers

  • Thread starter Thread starter Greg Kline
  • Start date Start date
G

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
 
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?
Click to expand...

your numbers in A2:Z2 then:

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


Regards
Claus B.
 
Back
Top