Displaying a value when there is a value in another cell

[PondDweller]

Hi,

I'll do my best to decribe what I'm trying to achieve - please refer to the attached worksheet. On entering a value into cell C7, I'd like the value of the adjacent column D7 to be displayed in F6. Then when a value is entered in manually into C8, it will then update and put the value of D8 into F6. The idea is an individual will enter a value each week, updating that value. I intend to hide column D.

Does that make sense?

It is probably super simple, sadly not an xls expert - Thanks, PondDweller

[NBVC]

Try:

=INDEX(D:D,MATCH(9.999999E+307,C:C))

this places value in column D corresponding to last found number in column C

[PondDweller]

Thanks for the help - it works perfectly - Regards Pond