Why INDEX-MATCH is better than VLOOKUP. There are many ways of looking up and retrieving values from a table of data in Excel. The VLOOKUP() and HLOOKUP() functions are widely used because of their simplicity, but they have some limitations and can fall down in certain situations. The INDEX(MATCH()) combo is a far more robust and reliable method.Why to use VLOOKUP in Excel?
VLOOKUP only works with data that's organized in columns (e.g., in vertical sections), meaning that your data most likely has headers in the top row of cells but not in the far-left column of cells. If your data is organized by rows instead, you'll won't be able to use VLOOKUP to find a value.How do you look up values in Excel?
1. Select a cell to put the result, and click Kutools > Formulas > Look for a value in list. See screenshot: 2. In the popping Formula Helper dialog, click to select all the data range into Table_array, select the look up value into Look_value, and then select the column range you want to return to Column.