Using Index and Match versus Vlookup in Excel

I recommend Index and Match instead of Vlookup due to its ability to column insertion within the range. While Vlookup requires the user to input a number to identify the column within the range to perform the lookup, when using Index-Match the user specifies both the...