<div>
Hlookup will only return one. For more than on you probably have to go to VBA
</div>


Hlookup will only return one. For more than on you probably have to go to VBA

<div>
NB_VC:<br />
<br />
That's the PERFECT solution!!!!<br />
<br />
Thousand thanks,<br />
EEH
</div>


NB_VC:

That's the PERFECT solution!!!!

Thousand thanks,
EEH

<div>
<div class="content wysiwyg-content">
I have a 6-column table and I'd like to output the column header for each row of the max-value column. &nbsp; &nbsp;Ok, that may sound confusing... here's an example:<br />
<br />
<br />
A &nbsp; &nbsp; B &nbsp; &nbsp; C &nbsp; &nbsp; D &nbsp; &nbsp; E &nbsp; &nbsp; F &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Best<br />
98 &nbsp; 97 &nbsp; 88 &nbsp; 99 &nbsp; &nbsp;76 &nbsp; 81 &nbsp; &nbsp; &nbsp; &nbsp;D<br />
92 &nbsp; 93 &nbsp; 91 &nbsp; 92 &nbsp; &nbsp;95 &nbsp; 97 &nbsp; &nbsp; &nbsp; &nbsp;F<br />
98 &nbsp; 89 &nbsp; 88 &nbsp; 97 &nbsp; &nbsp;96 &nbsp; 98 &nbsp; &nbsp; &nbsp; &nbsp;A, F<br />
<br />
Only challenge maybe the 3rd row where A and F have the same max value. &nbsp; <br />
<br />
How can this be accomplished (via HLookup)?<br />
<br />
EEH
</div>
</div>


I have a 6-column table and I'd like to output the column header for each row of the max-value column.    Ok, that may sound confusing... here's an example:


A     B     C     D     E     F           Best
98   97   88   99    76   81        D
92   93   91   92    95   97        F
98   89   88   97    96   98        A, F

Only challenge maybe the 3rd row where A and F have the same max value.   

How can this be accomplished (via HLookup)?

EEH

HLookup

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