All Excel users know how to use VLOOKUP and how much useful it is. But most of the excel users has never used INDEX & MATCH functions in excel.  Both have certain features that make it superior to VLOOKUP in many situations. INDEX MATCH is designed for vertical lookups, which is the task that VLOOKUP…