[solved] find max and display corresponding cell

[kamelkid2]

excel 2007

column UP i have a list of numbers. i need to find the highest number in that and display the text in column A of that row. i can do all of these separately but i am struggling to bring them together in one statement. any help would be much appreciated

[ChemistB]

Column UP? Okay, for column U for example;

=INDEX($A:$A,MATCH(MAX($U:$U),$U:$U,0))

Does that work for you?

[kamelkid2]

Column UP? Okay, for column U for example;

=INDEX($A:$A,MATCH(MAX($U:$U),$U:$U,0))

Does that work for you?

lol no it is column UP (this program is very very large but is still quite fast on a below average computer. today i have found a few ways to improve efficiency and remove many of the helper columns i have but it will only be maybe 100 or so columns

however =INDEX($A:$A,MATCH(MAX($UP:$UP),$UP:$UP,0)) works beautifully thank you for your time