I'm looking for help on the following :
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).