something like:

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

Where A2:B31 is the table of info in your first worksheet.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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