Index the value with LARGE() Query

[mart_mrexcel]

I was trying to get the value of the header (i.e. A1:C1) where it has the latest data (regardless of the number whether high or low. The formula I used perfectly returns the correct output when my data starts from A1.

=IFERROR(INDEX($A$1:$C$1,LARGE(IF($A$2:$C$2>0,COLUMN($A$2:$C$2)),ROWS(A$1:A1))),"")

However, when I push my data away from column A (for example i start my data at column B or C), the formula gets a wrong value or it becomes blank if I push more forward.

	A	B	C	Expected Output
1	2022	2023	2024
2	0	9

 

[Cubist]

You didn't show the expected output but maybe this?

Book1
	A	B	C	D	E
1	2022	2023	2024
2	0	9			2023
Sheet8

Cell Formulas
Range	Formula
E2	E2	=XLOOKUP(TRUE,A2:C2<>"",$A$1:$C$1,,,-1)

 

[Tetra201]

Try =IFERROR(INDEX($A$1:$C$1,LARGE(IF($A$2:$C$2>0,COLUMN($A$2:$C$2)-COLUMN($A$2)+1),ROWS(A$1:A1))),"")

 

[mart_mrexcel]

=XLOOKUP(TRUE,A2:C2<>"",$A$1:$C$1,,,-1)

Works perfectly

 

[mart_mrexcel]

Try =IFERROR(INDEX($A$1:$C$1,LARGE(IF($A$2:$C$2>0,COLUMN($A$2:$C$2)-COLUMN($A$2)+1),ROWS(A$1:A1))),"")

Works perfectly

 

[mart_mrexcel]

Thank you guys. Have a great day ahead.