Title sounds a bit weird, but it's really pretty simple (yet I'm posting a question about it, so apparently it's not that simple to me).

I'm looking for a formula that will get the value of a cell in the current row (say, C16) and find the last occurrence of that value in that column (C), only above the current row. Extra points for returning the value in column G of the last occurrence row.

I'm basically trying to find the last time a name (C16) occurred in a list (Column C) and see what weekday it was (column G).

I appreciate the help :beer: