Last non-zero column in row range and return value from different row

[KGee]

I want to check a range for the last non-zero value in row 35 from columns R-AC. The value I want to return is the text that matches that column but in row 32. Using the first formula in my current data, it returns a value of 28 which is correct as that corresponds to column AB in this case. The second formula gives me "AB32" which is the cell I want to return. I tried adding the "cell" function in the third formula but it doesn't take as I have it written. Open to alternatives if there is an easier method.

=IF(COUNTA(R35:AC35)=0,"",MAX((R35:AC35<>0)*(COLUMN(R35:AC35))))

=SUBSTITUTE(ADDRESS(1, IF(COUNTA(R35:AC35)=0,"",MAX((R35:AC35<>0)*(COLUMN(R35:AC35)))), 4), "1", "")&32

=CELL("CONTENTS",SUBSTITUTE(ADDRESS(1, IF(COUNTA(R35:AC35)=0,"",MAX((R35:AC35<>0)*(COLUMN(R35:AC35)))), 4), "1", "")&32)

 

[Fluff]

How about

=Lookup(2,1/(R35:AC35<>0),R$32:AC$32)

 

[KGee]

It always ends up being so simple. That works exactly as needed. Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.