INDEX MATCH is a powerful combination that allows you to do simple and advanced lookups in Excel. In this article, I'll show you 10 examples of using this.