Step 1 Click on the cell where the VLOOKUP function needs to be applied ie. This video explains how to use the Vlookup function in Excel to compare two table and pull matching data how to Vlookup in multiple sheets with multiple cr. Type in the equal sign then VLOOKUP and select the suggested function.
The first step to effectively using the VLOOKUP function is to make sure your data is well organized and suitable for using the function.
From within sheet 1 click the cell that you ultimately would like student names to be stored in in this case its C7. The Vlookup is one of the most popular functions in Excel but until you fully understand it it may initially appear complicated. We can use the VLOOKUP function with the help of a simple syntax. For example we put the cursor in cell F5.