How to look up a value?

[Guest]

Refer to the post in General Question

There are 2 lists of value under Column A & B,
Does anyone have any suggestions on how to look up the largest value under
column B and return the value on the same row on column A.
Thank you for any suggestion
Eric

 

[JE McGimpsey]

One way:

=INDEX(A:A,MATCH(MAX(B:B),B:B,FALSE))

 

[Guest]

Try: =INDEX(A:A,MATCH(MAX(B:B),B:B,0))

 

[Guest]

Thank you
Eric

 

[Guest]

welcome !