data associated with latest date

[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

 

[Luke M]

something like:

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

Where A2:B31 is the table of info in your first worksheet.

 

[Max]

Indicatively: =INDEX(Col2,MATCH(Max(Col1),Col1,0))
where
Col1 = Dates
Col2 = Inventory amounts
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik

 

[tcek]

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?

 

[Max]

"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]

Fantastic..thanks

"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