Thread: What Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wsturdev wsturdev is offline
external usenet poster
 
Posts: 2
Default What Function

I have a table of cells:

A B C D E
1/1/07 5
1/15/07 6
2/1/07 3
(empty) 2
(empty)
(empty)
(empty)
etc.
What formula do I use to look up the highest value in column A and retrieve
the value from THE NEXT ROW in column E. (I need to retrieve the 2)