Thanks Shane, but I am getting a $0.00 value. Perhaps the following
additional description will help. The fund worksheets have the dates in
column A & the corresponding unit prices in column C. The summary sheet has
the names of the funds (worksheets) in column A & the most recent unit price
for each in column C.

"Shane Devenshire" wrote:

Hi,

Try something like this

=LOOKUP(9^9,Sheet2!$A$1:$A$99,$B$1:$B$99)

This assumes the dates are in column A and in ascending order with the
values in column B.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Don" wrote:

I am developing an excel workbook to track retirement funds. Each worksheet
represents a separate fund. The last worksheet contains a summary of the
various funds including latest unit price, number of units, etc. From each
worksheet (fund) I want the workbook to find the most recent entry (from the
date column) & corresponding unit price (from the price column on the same
row) & transfer this information to assigned cells in the summary sheet.
What function/programming is required to make this work?