23 things you should know about VLOOKUP How VLOOKUP works VLOOKUP is a function to lookup up and retrieve data in a table. ... VLOOKUP only looks right Perhaps the biggest limitation of VLOOKUP is that it can only look to the right to retrieve data. ... VLOOKUP finds the first match In exact match mode, if a lookup column contains duplicate values, VLOOKUP will match the first value only. ... More items...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 I create a VLOOKUP?
Click the cell where you want the VLOOKUP formula to be calculated. Click "Formula" at the top of the screen. Click "Lookup & Reference" on the Ribbon. Click "VLOOKUP" at the bottom of the drop-down menu. Specify the cell in which you will enter the value whose data you're looking for.