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.
 

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

lookup and return column number 2
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
Locate text in range (multiple occurrences) and report other cell insame column? 10
Figuring out a lengthy formula. Probably quite simple... 3
Find 2 values & return row number 1
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
help on a formula (match and etc..) 1
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2

Back
Top