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" wrote:
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