View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default 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