How to use Excel Index & Match (Sinhala/සිංහලෙන්)

Quickly learn all you need to know about INDEX & MATCH to get a quick start.
How to do Index Match in Excel: The basics. Watch this video tutorial to find out how you can use Index & Match for more complex lookup problems. This video shows you how Index Match works with a simple and to the point explanation. It first shows you how Index works on its own and then how Match works and then puts the two Excel functions together.
INDEX and MATCH is more flexible than VLOOKUP.
Here are 3 reasons why Excel experts generally substitute VLOOKUP with INDEX and MATCH.
1. Unlike VLOOKUP, which searches only to the right, INDEX and MATCH can look in both directions - left and right.
2. INDEX & MATCH can perform two-way lookups by both looking along the rows and along the columns to find the intersection within a matrix.
3. INDEX & MATCH is less prone to errors.