data associated with latest date

  • Thread starter Thread starter tcek
  • Start date Start date
T

tcek

I have two columns. Column one has the dates of the month and the second
column has inventory amounts for that date. The inventory amounts is paste
linked to another worksheet. I have the data in column 2 to show up in the
linked worksheet for the latest date. I am using =max(date1...date31) to find
the lasted date. Any suggestions to transfer the associated data to the
linked field would be greatly appreciated
 
something like:

=LOOKUP(MAX(date1....date31),A2:B31)

Where A2:B31 is the table of info in your first worksheet.
 
Do i acutally use "Col2" and "Col1" or the column titles in row 1? would the
Col1 in the max statement have the row range included?
 
"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
 
Fantastic..thanks

Max said:
"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
Click to expand...
 
Back
Top