I am stumped trying to figure how to accomplish the following in excel. I am looking up a value in an array that will have multiple instances but another colum has different dates. I am trying to return the most recent date and which row it is in. I can accomplish this if I sort the data and use match to find the colum in descending order. However, the data may not always be in the correct order and I am trying to make it so it does not rely of always ensuring it is in order.

For instance, my data looks as follows:

Name Data Date
x Data 1/1/2018
y Data 10/10/2018
x Data 1/1/2019
z Data 12/12/2018

I want to be able to search for X and find the most recent date without sorting the data.

If there are any solutions or recommendations to this, your assistance with be appreciated.