ELO ranking lookup problem

[rugbytrader]

Hi,

I'm having an issue creating a lookup on my ELO ratings table
I'm trying to put a formula in E39 that will look up the value in C39 and compare it to the values in C29:D38, find the equivalent value then pull the value in from the corresponding cell at Z29:AA38
Additionally, as the sheet gets bigger there will be multiple repeats of values in C29:D38, at the moment C39 is looking for the value SUN, I need to make sure it just pulls the value of the last SUN from the range, starting from the bottom

thanks for any help