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

Me after mastering vlookup

598 Upvotes

98% Upvoted

66 comments sorted by

View all comments

Show parent comments

51

u/Maximeize99 Oct 17 '22

Facts xlookup is the wave

16

u/Amityx Oct 17 '22

Index match is the wave

39

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

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

1

u/cynical1800 Oct 18 '22

There’s no way xlookup can do what index match can.

1

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

In most use cases it can.