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

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

Similar Threads

Sumproducting counting blanks 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Figuring out a lengthy formula. Probably quite simple... 3
Locate text in range (multiple occurrences) and report other cell insame column? 10
lookup and return column number 2
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Searching a table of data using an array and returning the array's header?!? 4
INDEX/MATCH Formula? 5

Top