Hi guys.
For the love of my life I can't work out a Max if formula.
What I am trying to achieve here is to get the correspondent value from C to the latest date in column A.
My idea was to get an array of the same fruits, then with the max get the largest date.
Then try to match index match it...