Get the last value in a range in Google Sheets

[@yagisanatode]

If you just want to use a simple function called LAST_VALUE() in Google Sheets, you should check out my Named Function pack! yagisanatode.com/products/named-function-pack/

[@Vlath]

tnx

[@andhikamrk7633]

thank you very much, this help me. this method has similiar result as TAKE function in excel, since Google sheet doesn't have it.

[@naungsai]

How about the lookup column is with arrayformula?

[@yagisanatode]

Hey there. I am not 100% sure what you are asking for here.

[@IndraSanjaya1021]

Sangat membantu sekali
Terimakasih