find last row for specific text value in cell within tabel

Dear All,

I am new to this forum.
I am trying to find a solution for the following; within a tabel with several columns I am trying to find the last row (preferably column with the date for which the last specific value has been found in the table).
See attached example.
With vertical look-up I can't solve it and on the internet I only see VBA solution for which I have no experience. As I am unable to attach an excelsheet I will show you the tabel and the output I want

Date Cat 1 Cat 2 Cat 3
1/1 Apple Apple Apple
1/2 Pear Nut Pear
1/3 Apple Nut Nut

The whole tabel I from Date (left top) to bottom right (nut)

Output I would like to have:
Apple 1/3
Nut 1/3
Pear 1/2



Regards,

Maarten