INDEX and MATCH Solutions

The INDEX-MATCH combination is an advanced technique that can solve many look up problems. The two functions are useful, but together they provide a range of solutions to common look up requirements.