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.Why is index match better than VLOOKUP?
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.How do you find a match in Excel?
How to enter the MATCH formula in an Excel Sheet. 1. Select the cell in which you want to place the formula. 2. Type the formula as =MATCH(. 3. Then enter the value that you would like to find. This can be a number, a string, a cell address or a combined expression with a wildcard character as shown above.