Formula Looking for first non blank cell

[bgrish3]

I have a spreadsheet to track my mileage for my car attached.

In J15 (Merge Cell) I want the mileage for the current week to populate from column D. For example, if the last week I input my mileage was row 5 I want "768" to automatically populate, but as soon as I put in my mileage for Cell E6 I would like the corresponding mileage (960 in cell D6) to automatically show up.

Basically need a formula that finds the first blank cell in column E and go up one row, then copy the corresponding cell in column D.

Thank you!

[AliGW]

How about this?

=INDEX($D$2:$D$170,MATCH(TODAY(),$B$2:$B$170,1))

Or maybe this?

=INDEX($D$2:$D$170,MATCH(99^99,E:E)-1)

Both produce the result you want.

[bgrish3]

How about this?

=INDEX($D$2:$D$170,MATCH(TODAY(),$B$2:$B$170,1))

So this worked for the mileage I put in today. How will it change from 768 (D5) to 960 (D6)?

[AliGW]

When today gets to the next date on the list in B it will change.

I have added an alternative formula above.

[modytrane]

this works too:

[bgrish3]

When today gets to the next date on the list in B it will change.

I have added an alternative formula above.

Awesome! thank you!

[AliGW]

You're welcome!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.