Vlookup Function From Another Sheet. B 5 c 104 2 0. The generic formula to vlookup from another sheet is as follows.
Vlookup b5 sheet2. Vlookup lookup value sheet range col index num range lookup as an example let s pull the sales figures from jan report to summary sheet. Click on cell c2 and drag down the cell from the corner to apply the formula in all the below cells as shown.
Now mention the column number as 2 and range lookup as 0.
Using vlookup from another sheet is very similar to using vlookup on the same sheet. It must be in the first column of the sheet range. In summary sheet open the vlookup function. Vlookup lookup value sheet range col index num range lookup as an example let s pull the sales figures from jan report to summary sheet.
