Now we need to mention the row number ie from which row of the main table we are looking for the data. This helps you check your entries. For example if you specify B2.
Select cell F2 in this case as we are looking up the item using the part number.
The Syntax for VLOOKUP is. Click the cell where you want the VLOOKUP formula to be calculated. Now we need to mention the row number ie from which row of the main table we are looking for the data. In this case it will be the cell next to Last Name.