Last Result in a range

[vonmunchy]

How to get the last result in colum G automatically?

[TMS]

One way:

Please Login or Register  to view this content.

[vonmunchy]

One way:

Please Login or Register  to view this content.

Even if the current row was not a match, I want the to appear from the last match

[TMS]

Have you tried the formula?

[vonmunchy]

yes i did. it doesnt work

[TMS]

What is/are your expected result/s and where do you want it/them to appear. I guess I misunderstood your requirement so please explain the logic you need to be applied.

[vonmunchy]

Attachment 765458

If in "Draw" Colum, if the result was apple, i want in "Type" column to have apple unless i get lattice. And from that point onwards i want "Type" colum to have Lattice unitll i get an apple next. Hope you undestood what im trying to explain.

I found that xmatch can work to get the last match id but i cant seem to use it with if function

[Bo_Ry]

Please try at G5

=IF(F5<>"Non",F5,G4)

or
=XLOOKUP(TRUE,F$5:F5<>"Non",F$5:F5,,,-1)

or
=LOOKUP(2,1/(F$5:F5<>"Non"),F$5:F5)

[vonmunchy]

Yes, Thank you it works