Search code examples
dategoogle-sheetsconditional-statementsformula

Google Sheets: How Do I Return Row Value Associated With Second Most Recent Date in "Date" Column?

Let's say I have the following table below. I'm looking for a Google Sheets formula that would return the value associated with the second most recent date.

So I would want to see the value 41 returned by a cell formula (associated with 1/15/2022 date).

1/1/2022 52 1/8/2022 53 1/15/2022 41 1/22/2022 37

What is the formula to do this?

Edit: The formula would need to work if I had a third or fourth columns as well --> columns C and D. So what is the value in column C associated with the second most recent date in column A...

Solution

  • You may try:

    =vlookup(large(A:A,2),A:B,2,)

    enter image description here