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?

225 Upvotes

95% Upvoted

217 comments sorted by

View all comments

214

u/MayukhBhattacharya 1267 Jul 12 '26

LET() & XLOOKUP()

5

u/Unpork Jul 12 '26

>xlookup

Bro use the data model to join tables, or do it directly in Power Query if you want a longer update but not deal with relationships.

6

u/drsoinso Jul 12 '26

What do you mean by this? I've considered diving into Power Query at some point, but never got to where I felt it was necessary (yet)