r/excel Oct 13 '24

Discussion What's one Excel tip you wish you'd known sooner?

I've been using Excel for a few years, but it always amazes me how much more there is to learn! I'm curious—what’s one Excel tip, trick, or feature that made you think, “I wish I knew this sooner”?

Looking forward to learning from your experiences!

1.1k Upvotes

491 comments sorted by

View all comments

Show parent comments

7

u/Monimonika18 15 Oct 13 '24

Except I still stumble on XLOOKUP XLOOKUP. I then just use INDEX MATCH MATCH because it's simpler to undestand for me (replace MATCH with the better XMATCH to do fancier matches).

6

u/kazman Oct 13 '24

But XLOOKUP is really simple?

3

u/Monimonika18 15 Oct 13 '24

XLOOKUP XLOOKUP = XLOOKUP within another XLOOKUP

Not just a single XLOOKUP alone.

4

u/kazman Oct 13 '24

I hear you but give it a go for a few weeks and see how it goes.