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
|