Find the first occurence of a value in range of cells & return the the column header label

**bparrott** · 09-09-2013, 05:32 PM

How can i find the first occurrence of a value in a range of cells. If the value is found then return the columns header label. If the value is not found, then return text "none".

Attached spreadsheet with example data set.

Thank you all!!

**ajryan88** · 09-09-2013, 06:23 PM

Hi,

In cell A2, use this formula:

Formula:

Please Login or Register  to view this content.

Then drag it down as far as is necessary.

Hope this helps

**Tony Valko** · 09-09-2013, 06:44 PM

Try this...

=IFERROR(INDEX(B$1:K$1,MATCH("Yes",B2:K2,0)),"None")

Copy down as needed.

Find the first occurence of a value in range of cells & return the the column header label

LinkBack

Thread Tools

Rate This Thread

Display

Find the first occurence of a value in range of cells & return the the column header label

Re: Find the first occurence of a value in range of cells & return the the column header l

Re: Find the first occurence of a value in range of cells & return the the column header l

Thread Information

Users Browsing this Thread

Similar Threads

Find True in one of 3 columns and return column label

[SOLVED] How do I find the first occurence of a series of data in a range and return the value

[SOLVED] How do I return a header of column based on a range of cells containing specific data?

Find the row header and column label from a cell reference

Find last numerical value in row range and return the column header

Bookmarks

Bookmarks

Posting Permissions