"Indicatively" means that these would be your ranges in the expression

Example
Col1 = dates range, eg: A2:A30
Col2 = corresponding inventory amounts range, eg: B2:B30

Hence: =INDEX(Col2,MATCH(Max(Col1),Col1,0))
would be actually this:
=INDEX(B2:B30,MATCH(Max(A2:A30),A2:A30,0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"tcek" wrote:
Do i actually use "Col2" and "Col1" or the column titles in row 1? would the
Col1 in the max statement have the row range included?