Index and match doesn't always work
I was wondering if anyone had come across a technical issue with index and match or if it's something I am doing wrong (the formula is definitely correct).
I have a critically important index and match on a large number of sheets but it has stopped working. Replacing it with vlookups work so I have a fix but I'd rather find out what has gone wrong before replacing a huge number of formulas, if anyone has any ideas?
Help Article Resources
Check out the Formula Handbook template!