LOOKUP function

Question

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

patrick2788 · Answer

Mhernandez714&nbsp;A 365 solution:&nbsp;&nbsp;=TAKE(TOROW(G55:R55,3),,-1)&nbsp;

mhernandez714 · Answer

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

patrick2788 · Answer

Mhernandez714&nbsp;I see your data has 0s and not blanks. Try this:=XLOOKUP(TRUE,G55:R55&lt;&gt;0,G55:R55,,,-1)

mhernandez714 · Answer

This worked! Thank you so much 🙂

patrick2788 · Answer

You're welcome!

Forum Discussion

LOOKUP function

Share

Resources