Finding last value in a row

[rambollet]

What formula will return the the first value to the right?

For example: A1=empty cell, B1=3, C1=empty cell, D1=0, E1=5, F1=empty cell.
What does the formula need to be in G1 to return the value of the first cell to the left than contains 0 or a value, or in this case 5 (E1)

 

[Aladin Akyurek]

Rehashing an old thread here, but can this formula be altered to find the last text value in a range (similar to the cell references provided above)?
Thanks!
CG

Yes, we have;

=LOOKUP(REPT("z",255),A2:A10)

would yield the last text value even if it's a formula generated blank (i.e., "").

=MATCH(REPT("z",255),A2:A10)

would yield the relative position of the last text value.

Note. REPT("z",225) creates a lengthy string that is alphabetically last. And it's due to Mark W.

 

[Curious Georgian]

This works perfectly, and I appreciate your providing both the Match and Lookup explanations. I've combined this with an index function and it works just as needed.
Thanks to you and Mark W!
CG

 

[Aladin Akyurek]

This works perfectly, and I appreciate your providing both the Match and Lookup explanations. I've combined this with an index function and it works just as needed.
Thanks to you and Mark W!
CG

That is great. Thanks for providing feedback.