Index and Match (?) for the last non-zero value in a row

[trypsin25]

Hello! I've tried several examples to determine the End Date (headers in A1:P1) by each row for the last non-zero value. I've been unsuccessful and could use some help. I believe the issue in my approach is there can be zeros between >0 values.

I am looking for a formula that would return the value as listed in the End Date column.

Thank you in advance for your help!

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=lookup(2,1/(b2:p2<>0),b$1:p$1)

 

[trypsin25]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=lookup(2,1/(b2:p2<>0),b$1:p$1)

Wow!!! It works and was so easy!!! Thank you so very much for the help!!

 

[Fluff]

You're welcome & thanks for the feedback.