Retrieving Date

[Walley]

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

 

[Lars-Åke Aspelin]

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

Try this formula in cell D3:

=INDEX(A3:A8,MATCH(1100,B3:B8))

Don't forget to format cell D3 as date.

Hope this helps / Lars-Åke