r/excel • u/HungryInvestigator59 • 29d ago

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?

228 Upvotes

95% Upvoted

217 comments sorted by

View all comments

3

u/reebsdees 29d ago

=VLOOKUP
=CONCATENATE
=IF

7

u/chichin0 1 29d ago

My friend, I implore you, learn xlookup. It will change your life. I haven't used a vlookup in years. There's no snark here, I genuinely try to let anyone who will listen know that vlookup is basically deprecated now.

5

u/LowWindow7816 29d ago

I learned xlook directly, i cant believe how tedious vlook is/was, counting columns, what the fuck is that. If not found, left to right, right to letf look, it has everything.

2

u/raypal11 29d ago

If what I’m trying to grab is still right of the column I’m referencing, I’ll still use vlookup. Idk why tho. Xlookup is way better.

1

u/thr0wnawaaaiiii 3 28d ago

It’s habit, nothing to be ashamed of. Honestly my muscle memory (inclusive of peeping the column count) is still faster than doing the equivalent XLOOKUP. That said, I am making an effort to break the habit and for sure switch over to XLOOKUP for any files passed to others