Pull a column header from a row of numbers


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
 
Ad

Advertisements

C

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top