Hi!
I use Excel 2007. I have worksheet with two main columns, one for date
(column A) and second for values (column B) which I inserted every day, as
shown in this example:

A B C
D
3 22 August 100

4 23 August 105

5 24 August 102

6 25 August

7 26 August

8 27 August

In cell C3, I use function LOOKUP(1100;B3:B8) to retrieve the value of the
last cell with value (in this example B5), I mean the cell before the first
empty cell. In D3, I want to have a function to retrieve the date of the cell
which is beside last cell with value in column B, in this example cell A5.
Thanks for the help