In this article we will learn about how we can find the matching values from not adjacent list, we can use a combination of INDEX & MATCH functions to get the output. INDEX: Returns a value or reference of the … Continue reading How to Use Index with Match Function in Microsoft Excel 2010