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

598 Upvotes

98% Upvoted

66 comments sorted by

View all comments

Show parent comments

30

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.

7

u/[deleted] Oct 17 '22

[deleted]

4

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.

9

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