I need the value form the furthest cell to the right from selected cells when its text as a result of a formula

[damian_r_Home]

Morning All.

I need help as follows.
I need a formula in cell Y8 (the yellow cell) that looks at the green cells and shows whatever value is in the furthest cell to the right (so currently it should show P02)
However, the green cells all contain a formula, I've shown the formula in each of those cells directly above them in orange.

Your help on this really really would be appreciated.

D

 

[shift-del]

Hi

=LOOKUP(42,1/(AA8:AT8<>""),AA8:AT8)

 

[damian_r_Home]

Morning shift-del

I've no idea how that formula works but it certainly appears to have done the trick!

Thankyou!!!