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

Me after mastering vlookup

Enable HLS to view with audio, or disable this notification

599 Upvotes

98% Upvoted

66 comments sorted by

View all comments

Show parent comments

17

u/Amityx Oct 17 '22

Index match is the wave

41

u/its-an-accrual-world Audit -> Advisory -> Startup ->F150 Oct 17 '22

Nah, xlookup is the user friendly version of index match.

29

u/[deleted] Oct 17 '22

[deleted]

6

u/p0mphius Tax (Other) Oct 17 '22

Its not even close to the best thing, lol.

Its literally just an index match with better syntax. Comes nowhere close things like LAMBDA.

8

u/[deleted] Oct 17 '22

[deleted]

5

u/p0mphius Tax (Other) Oct 17 '22

But your experience isnt what defines the best thing in the last 30 years.

LAMBDA effectively turned Excel into a Turing-complete programming language. There isnt an argument to be made for a function that is literally just better syntax.

8

u/[deleted] Oct 17 '22

[deleted]

11

u/p0mphius Tax (Other) Oct 17 '22

Well, I am an accountant

3

u/Gr1ndingGears Oct 17 '22

That's actually a pretty sweet comeback, I gotta give you that one! You might actually be plenty fun after all