I use index match frequently and my formulas work perfectly fine in every version of excel until I moved to a new company that uses 365 (this was embarrassing).

I do not want to use x lookup. It actually has limitations that make it unusable for me.

Is there any way around this? Why does Microsoft constantly pull stuff like this? It’s infuriating.