How to look up a value?

E

Eric

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
 
R

RobN

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
 
P

Pete_UK

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
 
E

Eric

Thank everyone very much for suggestions
Eric

Pete_UK said:
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
Click to expand...
 
Top