Index and Match function in Excel

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…

Using the VLOOKUP and HLOOKUP Functions

Today in this article, we will see VLOOKUP & HLOOKUP which are the most useful, yet most mis-understood function in Excel. Function searches for a value in the first column of a table array and returns a value in the same row from another column in the table array. The V in VLOOKUP stands for…