LOOKUP function

[Mhernandez714]

Hello,

I am working on creating a formula to auto-populate cell B6 based on the last value in row G55:R55. Any help offered is greatly appreciated. Thank you!

[#2]

@Mhernandez714 

A 365 solution:

=TAKE(TOROW(G55:R55,3),,-1)

[#3]

@Patrick2788 The formula did not work. What am I doing wrong?

[#4]

@Mhernandez714 

I see your data has 0s and not blanks. Try this:

=XLOOKUP(TRUE,G55:R55<>0,G55:R55,,,-1)

[#5]

This worked! Thank you so much 🙂

[#6]

You're welcome!