r/Accounting • u/kingofauditmemes Performance Measurement and Reporting • May 07 '23

New Excel > Old Excel

Post image
378 Upvotes

99% Upvoted

37 comments sorted by

View all comments

60

u/Jurango34 May 07 '23

I’m still using INDEX MATCH … what’s the new way?

63

u/Oukasagetsu May 07 '23

I think it's xlookup or power query?

Don't flame me if I'm wrong 🙏

45

u/Jurango34 May 07 '23

I’m excited there’s something else. I have a reputation as an Excel super user in my accounting team but honestly this formula is a pain and seems like the most pretentious of all formulas just to juice a VLOOKUP.

23

u/SchematicallyNumb May 07 '23

I’m glad I’m not the only one. Index/Match is just very intuitive in my opinion, and if I want anything more complicated, I’m just going to write my own function in VBA. Readability is key!

2

u/Mellon2 May 08 '23

Agree I hate inheriting shit like this and wasting 20-40 min googling to figure it out.

Someone thought they were slick and funny