Find the summary of a cell connected to the most recent date.

I need to find the summary of a cell, but as more data is input by the user the summary needs to change to always identify the most recent date.

I have a table with Date, Forecast Weight and Actual Weight columns on tab 3 (called 'Weight'). This will be filled out by the user.

On tab 1 (called 'Summary') I need to show the Actual Weight connected to the latest date. The formula =WeightTab!A:1 for example won't work because as soon as another row of data is added, the cell A1 will be out of date.


I fear I may not have explained my problem very well so I've put together an example spreadsheet.


Thanks in advance for any help.

Tom