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.What does the VLOOKUP function do?
VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches.