Retrieving Date

W

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
 
L

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top