Display corresponding value in a column of a MAX datarange

[I_need]

I have a data range called "Recordings" with the following data source:

=Cover!$BL$76:$BL$80,Cover!$BN$76:$BN$80,Cover!$BP$76:$BP$80,Cover!$BR$76:$BR$80,Cover!$BT$76:$BT$80

I am able to display the maximum value in Recordings by using the formula =MAX(Noise) However, I would also like to display the corresponding value in Column A of the max value. What formula do I use please?

Also, how will this formula deal with 2 identical max value? Will it display Column A value of the the first max value it finds?

[Fotis1991]

Hi

Try VLOOKUP, or INDEX & MATCH functions.

[I_need]

More information please.

I don't think vlookup can work as the data range is made up of multiple columns that share the same Column A value.

[Fotis1991]

...Yes..Same for us too... This means:"More information please. "

And even better,upload a small sample workbook