One way:

=INDEX($B$2:$L$2,MATCH(MAX($B$54:$L$54),$B$54:$L$5 4,FALSE))

In article ,
aduroche wrote:

Hello,

I have a range on which I am looking for the max value:
E51=MAX($B$54:$L$54)

Now, rather than extracting the cell's content, I'd like to extract the
cell's address, so that I can then display the content of that column's
header in range B2:L2.

Example:
If the MAX function in E51 above computes the content of cell H54, rather
than displaying the content of H54 I would like to display the content of H2.

Hopefully I'm making sense...

Thanks in advance for any help you can provide!

Alain