Computer Tutoring Logo
Est. 2002
Menu Button

Excel Tutorial: Using Index Match to compare two lists with Multiple Criteria


Comparing two lists with Multiple Criteria

Index Match Multiple Criteria

This tutorial is an addition to the Index Match using Multiple Criteria but with the advantage of comparing the values from two lists to bring back a value without any unique column identifying the row.

Before you go through this tutorial you might want to take a look at the Index Match multiple criteria tutorial I did previously. That Index Match tutorial also has step by step instructions to help you along your way.

The exercise file that goes with the above tutorial.