Need to identify last populated cell in a row.

[tbablue]

{=INDEX(J$4:AZ5,1,MATCH(TRUE,J5:AZ5<>0,0))}

this array formula (supplied by this forum - appreciated!) returns a value from the row 1 of the range J$4:AZ$5 based on the first populated cell found within row J5:AZ5.

This array formula does exactly what I need it to do.


I now need to identify the last populated cell within row J5:AZ5. Any ideas?

If you've tried to help me with this before - I appreciate your repeat attention. I acknowledge that my earlier description of my requirement was probably very confusing - hopefully, this is clearer.

 

[Jonmo1]

Try

=LOOKUP(9.99999999999999E+307,J5:AZ5,J4:AZ4)

Hope that helps...

 

[tbablue]

sorry - I should have explained.

ALL cells within my lookup range are populated by formula - so the cells themselves are not empty. It's just that some cells return a value.

I want to find the last cells in a row which contain a returned value.

I appreciate this puts a different spin on things.

Thanks in advance for any assistance offered.

 

[Jonmo1]

Does this work

=LOOKUP(TRUE,J5:AZ5<>0,J4:AZ4)

 

[tbablue]

Hi Jonmo1

Neither formula seems to work. Thanks for your attention.