Index And Match Formula in Excel

In Excel learn how to use the combination of Index and Match formula to look up a value with exact match. Index and match formula can lookup value in complex pattern and is way more powerful than Vlookup or any other lookup formula.