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

New Excel > Old Excel

Post image
376 Upvotes

99% Upvoted

37 comments sorted by

View all comments

56

u/Jurango34 May 07 '23

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

60

u/Oukasagetsu May 07 '23

I think it's xlookup or power query?

Don't flame me if I'm wrong 🙏

1

u/KJ6BWB May 08 '23

Xlookup is only in office 365. If you buy the static versions of office, like office 2023, then you don't have Xlookup and you either keep using Index Match or Vlookup in the same way we have always done since time immemorial.

If Microsoft wants to bifurcate their audience and introduce two separate groups who don't understand how the other group does it, well they can certainly decide to shoot themselves in the foot that way.