<div>
Here is an array-entered formula you might use:<br />
=IFERROR(INDEX($B$1:$G$1,S<wbr />MALL(IF(IN<wbr />DEX($B$2:$<wbr />G$7,MATCH(<wbr />&quot;Row 3&quot;,$A$2:$A$7,0),0)=10,COLU<wbr />MN($B$2:$G<wbr />$7)-COLUMN<wbr />($B$2)+1,&quot;<wbr />&quot;),COLUMNS<wbr />($B1:B1)))<wbr />,&quot;&quot;)<br />
<br />
To array-enter a formula:<br />
1. &nbsp;Select the cell, then click in the formula bar<br />
2. &nbsp;Hold the Control and Shift keys down<br />
3. &nbsp;Hit Enter, then release all three keys<br />
Excel should respond by adding curly braces { } surrounding the formula. <br />
<br />
The formula will return an empty string (looks like &nbsp;blank) if you don't array-enter it successfully. If so, repeat the steps.<br />
<br />
The formula is designed to be copied across and return successive header labels until there are no more cells containing 10 in &quot;Row 3&quot;. When the list is exhausted, the formula returns an empty string.
</div>


Here is an array-entered formula you might use:
=IFERROR(INDEX($B$1:$G$1,SMALL(IF(INDEX($B$2:$G$7,MATCH("Row 3",$A$2:$A$7,0),0)=10,COLUMN($B$2:$G$7)-COLUMN($B$2)+1,""),COLUMNS($B1:B1))),"")

To array-enter a formula:
1.  Select the cell, then click in the formula bar
2.  Hold the Control and Shift keys down
3.  Hit Enter, then release all three keys
Excel should respond by adding curly braces { } surrounding the formula.

The formula will return an empty string (looks like  blank) if you don't array-enter it successfully. If so, repeat the steps.

The formula is designed to be copied across and return successive header labels until there are no more cells containing 10 in "Row 3". When the list is exhausted, the formula returns an empty string.

ColumnHeadersWith10-Q28375537.xlsx

<div>
<div class="content wysiwyg-content">
Following formula only find he first occurrence of value 10 and returns the column header in row 1 .. how can I make it to find all occurrence of value 10 in the row and output corresponding column header in row 1?<br />
<br />
=INDEX($B$1:$G$1,MATCH(10,<wbr />INDEX($B$2<wbr />:$G$7,MATC<wbr />H(&quot;Row 3&quot;,$A$2:$A$7,0),0),0))
</div>
</div>


Following formula only find he first occurrence of value 10 and returns the column header in row 1 .. how can I make it to find all occurrence of value 10 in the row and output corresponding column header in row 1?

=INDEX($B$1:$G$1,MATCH(10,INDEX($B$2:$G$7,MATCH("Row 3",$A$2:$A$7,0),0),0))

Index and Match optimization

Content management (CM) is a set of processes and technologies that supports the collection, managing, and publishing of information in any form or medium. When stored and accessed via computers, this information may be more specifically referred to as digital content, or simply as content. Digital content may take the form of text (such as electronic documents), multimedia files (such as audio or video files), or any other file type that follows a content lifecycle requiring management.

Content Management

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.