To find last visible text in Highlighted Column

[fareedexcel]

Hello Experts,

I'm facing a challenge in picking the last visible value in highlighted columns. Please help. I have attached the sample file for your reference.

 

[shrivallabha]

You can use an IF construct like below which is simple but lengthy.
=IF(K3<>"",K3,IF(H3<>"",H3,IF(F3<>"",F3,IF(D3<>"",D3,IF(B3<>"",B3,"")))))

If rest of the cells are always blank then you can also use which will be easier to extend if you have more columns:
=IFERROR(LOOKUP(2,1/(B3:K3<>""),B3:K3),"")

 

[bosco_yip]

If you want to avoid data in non highlighted column cells

Try,

=LOOKUP(1,0/(T(OFFSET(B3,,{0,2,4,6,9}))<>""),T(OFFSET(B3,,{0,2,4,6,9})))

Regards

 

[fareedexcel]

Thanks for both your replies. Efficient Formulas.