How to look up a value?
 

There are two lists under column A and B,
Under column A, there is a list of date and under column B, there is a list
of price, and I would like to search for the maximum value under column B and
return the date under column A for this maximum value.
Does anyone have any suggestion on how to do it?
Thank for any suggestions
Eric

How to look up a value?
 

Have you looked at the Auto Filter facility? If your columns have headers,
click in a cell below the headers and then go to Data, Auto filter on the
menubar. Click the filter arrows that should appear next to the headers and
use the options there-in.

Rob

"Eric" wrote in message
...
There are two lists under column A and B,
Under column A, there is a list of date and under column B, there is a
list
of price, and I would like to search for the maximum value under column B
and
return the date under column A for this maximum value.
Does anyone have any suggestion on how to do it?
Thank for any suggestions
Eric

How to look up a value?
 

Try something like:

=INDEX(A1:A100,MATCH(MAX(B1:B100),B1:B100,0))

Adjust the ranges to suit, and format the cell as a date.

Hope this helps.

Pete

On May 3, 10:26 am, Eric wrote:
There are two lists under column A and B,
Under column A, there is a list of date and under column B, there is a list
of price, and I would like to search for the maximum value under column B and
return the date under column A for this maximum value.
Does anyone have any suggestion on how to do it?
Thank for any suggestions
Eric

How to look up a value?
 

Thank everyone very much for suggestions
Eric

"Pete_UK" wrote:

Try something like:

=INDEX(A1:A100,MATCH(MAX(B1:B100),B1:B100,0))

Adjust the ranges to suit, and format the cell as a date.

Hope this helps.

Pete

On May 3, 10:26 am, Eric wrote:
There are two lists under column A and B,
Under column A, there is a list of date and under column B, there is a list
of price, and I would like to search for the maximum value under column B and
return the date under column A for this maximum value.
Does anyone have any suggestion on how to do it?
Thank for any suggestions
Eric