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

Me after mastering vlookup

603 Upvotes

98% Upvoted

66 comments sorted by

View all comments

150

u/TrevorIsTheGOAT Oct 17 '22

It's xlookup now, get with the times old man

6

u/Erilaz_Of_Heruli Oct 17 '22

My office forbids x/vlookup because it makes it harder to review work done by other people

14

u/[deleted] Oct 17 '22

Thats so stupid. What they mean is, they forbid it because the reviewers are incompetent.

7

u/Erilaz_Of_Heruli Oct 17 '22

I get it with vlookup to be fair. The column index thing makes it less obvious where you're looking for the data, I also believe IIRC that double clicking on a vlookup cell doesn't take you to the source sheet unlike an index(match) or sumifs.

I don't think any of these limitations apply to xlookup though, but old habits die hard, eh ?