How to look up a value?
 

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

How to look up a value?
 

One way:

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

In article ,
Eric wrote:

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

How to look up a value?
 

Try: =INDEX(A:A,MATCH(MAX(B:B),B:B,0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
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

Thank you very much for suggestions
 

Thank you
Eric

How to look up a value?
 

welcome !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
Thank you
Eric