find last row for specific text value in cell within tabel

[maarten74]

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

 

[steve the fish]

Hi. Something like this should work:

=LOOKUP(2,1/(($B$2:$B$4=A9)+($C$2:$C$4=A9)+($D$2:$D$4=A9)),$A$2:$A$4)

where table 1 is in A1:D4 and result table in A9:B11.