Comparing Two Lists Using 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.
Need Help with INDEX MATCH, Lookups and Excel Formulas?
We offer live instructor-led Excel training for teams who need practical help with lookups, formulas, reporting and day-to-day spreadsheet work.
The exercise file that goes with the above tutorial.