How to use INDEX MATCH MATCH

How to use INDEX MATCH MATCH

10 September 2013

If you're using Excel and you've already learned how to use INDEX MATCH, you're well on your way to becoming proficient with Excel lookups. What INDEX MATCH MATCH offers you is a more powerful version of the formula.

Instead of just a vertical lookup, INDEX MATCH MATCH allows you to perform a matrix lookup, which is also known as a two-way lookup. This combination formula may initially seem complex because of its three individual formulas, but after you understand each component and how they interact, using this tool will become second nature to you.

INDEX MATCH MATCH is one of several lookup formulas you should learn to become adept in database theory.