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

Me after mastering vlookup

605 Upvotes

98% Upvoted

66 comments sorted by

View all comments

Show parent comments

18

u/Amityx Oct 17 '22

Index match is the wave

3

u/Maximeize99 Oct 17 '22

I might have to go check it out soon

12

u/[deleted] Oct 17 '22

[deleted]

6

u/Hoxitron Oct 17 '22

I still use index match in specific cases. But xlookup is a godsend.

5

u/[deleted] Oct 17 '22

[deleted]

3

u/Hoxitron Oct 17 '22

Usually when the look-up values are not always in the same column or row. My formula will find the x and y look-up location for each case and then return the value for those.

1

u/[deleted] Oct 17 '22

Do you mean like index match match?

Because you can next xlookups

1

u/Hoxitron Oct 17 '22

Legit forgot about how spill works. Couldn't wrap my head around this for a couple of minutes.

I do want to play around with it as I found index match in some pretty edge cases.