Return Last Non Blank Value (Data is not in a range)

[tantcu]

Hello,

I need your help to figure out how to return a last value in a non blank cell (and the data is not in a range situation).

I attached a sample data for your reference. The expected results are reflected in column K in the file.

Thank you!

[Fluff13]

How about
=LOOKUP(2,1/(C3:J3<>""),C3:J3)

[tantcu]

How about
=LOOKUP(2,1/(C3:J3<>""),C3:J3)

Thank you. Instead of C3:J3 range, can I limit it within cell C, E, G, I only?
Other cells may have other data that I don't want them to be involved.

[Fluff13]

How about
=LOOKUP(2,1/((C3:J3<>"")*(ISNUMBER(SEARCH("status",$C$2:$J$2)))),C3:J3)