5 July 2015
INDEX MATCH not working? This article provides the most likely causes of your problems with using INDEX MATCH.
If you're an advanced user of Excel, you've likely already made the switch from VLOOKUP to INDEX MATCH because of the several advantages that INDEX MATCH provides.
Within Excel, INDEX MATCH is one of the most prevalent formula combinations available. Despite this popularity, INDEX MATCH is by no means perfect and is still prone to errors. The following examples represent the most common mistakes made when using the formula combination.
Full article: Top mistakes made when using INDEX MATCH
