Forum Discussion

Mhernandez714's avatar
Mhernandez714
Copper Contributor
Sep 06, 2024

LOOKUP function

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!
Formulas and Functions
Mhernandez714's avatar
Mhernandez714
Copper Contributor

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

 

 

 

 

Patrick2788's avatar
Patrick2788
Silver Contributor
Sep 09, 2024

Mhernandez714 

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

=XLOOKUP(TRUE,G55:R55<>0,G55:R55,,,-1)
  • Mhernandez714's avatar
    Mhernandez714
    Copper Contributor
    Sep 09, 2024
    This worked! Thank you so much 🙂
    • Patrick2788's avatar
      Patrick2788
      Silver Contributor
      Sep 09, 2024
      You're welcome!

Resources