How do I find the last time a specific string is said in a column of a table?

Hi! I’m working on a large project and have gotten to a stage where I need to find the last time a specific string is stated in a column and get a value in a different cell on the same row. I have some ideas on how to do it, such as starting from the bottom and searching up but am not sure how to properly execute it.