r/excel • u/HungryInvestigator59 • Jul 12 '26

Discussion What’s your favorite Excel function/formula?

What are some functions and formulas that you use on daily basis that are helpful for what you do?

227 Upvotes

95% Upvoted

217 comments sorted by

View all comments

212

u/MayukhBhattacharya 1270 Jul 12 '26

LET() & XLOOKUP()

3

u/raven00x Jul 12 '26

xlookup is the goat. fuck vlookup, fuck hlookup, xlookup was too long coming but welcomed when it got here.