Changing the cell value automatically from the data range

Hi All

I have the data as shown in the attached file.

We have to receive the data for Actual Values and Target values on weekly basis, but that wnt happen due to some issues in data gathering. so sometimes we get the values filled in for 3 to 4 weeks at a time sometimes it stays same. Now in one cell we have to show the latest actual value available in the data range.

For Ex. if the receive the data for 4 weeks today the 4th week's Actual value should be displayed in one cell. and after 2 weeks if i receive the data for 6 weeks the value should change automatically to 6th Weeks actual value.

Please help me how can we achieve this in excel.

Thanks
kls

Yes, I have got the result. Thank you very much.