I'm looking for help on the following :

Exemple sheet

I need the word Frisbee to be put in the green cell

Any idea ?

The value researched will always be text, and depending on a date.

Edit : Just made the spreadsheet public and open to comments, sorry.

I have a column C with items acquired and a column B with the date of the acquisition. It's not sorted by date, so I first have to acquire the most recent date (with =TO_DATE(MAX(ARRAYFORMULA(B2:B9))) ), then I need to get the content of the cell that is corresponding to the date (on the same line, separated horizontally by one or more cell).

  • 2
    Could you expand your question to include some example cells, illustrating your problem? If the spreadsheet you link to should go away some day, the question will be useless. We like to keep as much information as possible within the actual question. Also, the spreadsheet you're linking to requires access. Did you make it public? Dec 16, 2013 at 17:51
  • Done, hope all the information needed is there.
    – Kylki
    Dec 16, 2013 at 19:24

1 Answer 1


You can use the following formula to get the "frisbee".




The QUERY will take both columns as dataset, but it will only show column C. Furthermore, it will sort column B descendingly (highest first) and the limit option will limit the result dataset to one row.

In this case, there's no need to calculate the highest date first.


I've copied your file and added my solution: FRISBEE

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.