Last data in row/return corresponding month

[onthegreen03]

Hi - I have monthly data in cells L7 to W7, with corresponding month in L6 to W6. I want to write a formula that looks for the last value entered on row 7 and return the corresponding month from row 6. In the example below I want to return "September 2021" in a pre-determined cell. When October data is entered, it will return "October 2021", and so on. Thanks!

 

[Toadstool]

Hi Onthegreen03,

Is this what you want?

Onthegreen03.xlsx
	K	L	M	N	O	P	Q	R	S	T	U	V	W
6	Result	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21
7	Sep-21	$5,500	$0	$6,250	$0	$3,333	$0	$0	$0	$0
Sheet1

Cell Formulas
Range	Formula
M6:W6	M6	=EOMONTH(L6,0)+1
K7	K7	=IFERROR(INDEX(L6:W6,AGGREGATE(14,6,COLUMN($L7:$W7)-COLUMN($K$6)/($L7:$W7<>""),1)),"No month etries")

 

[onthegreen03]

Thank you! Appreciate help.

 

[Toadstool]

Thank you! Appreciate help.

You're welcome.
Thanks for the feedback.