=INDEX(A:A,MATCH(MAX(B:B),B1:B65534))

Regards

Trevor


"Nick" wrote in message
...
This is probably easy one but I cant figure it out.
I want to get the field name/label from the same row in the column to the
left of the result of a MAX or LARGE function. Tried LOOKUP but data is
not
in order.

e.g.

A B
ReasonA 23
ReasonB 44
ReasonC 17 I would like MAX function to return 'Reason B'