It might be better to use :
=INDEX(A2:A10,MATCH(LARGE(B2:B10,1),B2:B10))
as it allows for the kth highest value's name to be displayed, by simply
changing the number at LARGE(B2:B10,number).
"Sanjeev" wrote:
Assuming the data is in cells A2:B10
You can use this Simple formula
=INDEX(A2:A10,MATCH(MAX(B2:B10),B2:B10))
Your Freind
Sanjeev Agarwal
"Fishbone" wrote:
I have a list with value_name and its value. Is there a formula that
can look down the list and pick the highest value and return the
value_name
For example
_Value_Name_ _Value_
Value A 5
Value B 10
Value C 33
Value D 8
Value E 51
Value F 32
Value G 47
Value H 9
Value I 41
So the formula would return Value E as its result.
Would be much appreciated :)
--
Fishbone
------------------------------------------------------------------------
Fishbone's Profile: http://www.excelforum.com/member.php...o&userid=11848
View this thread: http://www.excelforum.com/showthread...hreadid=395276