Formula to find last cell with a entry in the row and return the column heading name

[Nicole Jones]

Hi
I have been able to work out how find the cell with the last entry and return its value (=XLOOKUP("*?",VALUETOTEXT(B2:K2),B2:K2,"",2,-1)), I need assistance please to be able to return its column's heading, in the example below it is the Week # Value that I am needing.

Thank you in advance.

 

[hagia_sofia]

Hello, how about:

=XLOOKUP(FALSE,ISBLANK(B2:K2),$B$1:$K$1,,,-1)

 

[Nicole Jones]

Hello, how about:

=XLOOKUP(FALSE,ISBLANK(B2:K2),$B$1:$K$1,,,-1)

Perfect, thank you this works perfectly

 

[Fluff]

You could also use

=XLOOKUP("?*",B2:K2,B$1:K$1,"",2,-1)