Retrieving Date

  • Thread starter Thread starter Walley
  • Start date Start 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
 
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
Click to expand...

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
 
Back
Top