Jan 08 2021 08:34 AM
Jan 08 2021 10:50 AM
I'd create helper range at any place within workbook
With it formula for latest filled month could be
=LOOKUP(IFNA(INDEX($G$4:$R$4,XMATCH(,$G$4:$R$4)-1),$R$4),$T$4:$T$9,$U$4:$U$9)
Jan 29 2021 12:17 PM
Jan 29 2021 12:54 PM
If I understood the logic correctly that's like
that could be
=INDEX(R25:AC25,MAX(1,XMATCH(,R25:AC25)-1))
As a comment, that's always better to illustrate the question with sample file