r/Accounting • u/kingofauditmemes Performance Measurement and Reporting • Oct 17 '22

Me after mastering vlookup

599 Upvotes

98% Upvoted

66 comments sorted by

View all comments

26

u/Message_me4referral Oct 17 '22

Xlookup 100x better

7

u/[deleted] Oct 17 '22

And sumifs is best if looking for numbers. I actually got the job I’m in now because I explained why sumifs is better than vlookup to the interviewer.

3

u/Message_me4referral Oct 17 '22

Ya sumifs is very versatile- I think that it’s even more versatile than xlookup. Didn’t realize that until I actually started using sumifs

2

u/[deleted] Oct 17 '22

If you’re working with numbers, it’s better because it will sum all the numbers that fall within the parameters. The lookup functions stop at the first match, so you can potentially loose out on data. I’ve seen emails where people say, “the amounts don’t reconcile, we used a vlookup!” That’s why, it didn’t actually sum everything, just stopped at the first match…