How to use vlookup in excel for different sheets
![how to use vlookup in excel for different sheets how to use vlookup in excel for different sheets](https://i.ytimg.com/vi/Ajo3_XSWE0k/maxresdefault.jpg)
The above image is a snapshot of sheet1 where column C ‘Runs Scored’ is filled using the VLOOKUP formula. FALSE will return the exact match if the lookup is in range.Ĭlick on cell C2 and drag down the cell from the corner to apply the formula in all the below cells, as shown in the below image.3 is the column index-number which contains data in the 3 rd column in sheet2 and will retrieve data from the range A2: C7.And also, the’$’ sign is used to fix the data range, so it makes it easier to copy and paste in other cells. $A$2:$C$7 is the range of data in sheet2 where we are searching data for the jersey number so as to fetch the data for runs scored in sheet2.A2 represents the lookup value which is the jersey number, and it’s the same value in both the sheets.Let us see the steps below, which will explain the above steps and formula in detail.Īs we can see in above Step1, the formula entered in sheet1 in cell C2 is =VLOOKUP (A2, Sheet2!$A$2:$C$7,3, FALSE) where, We can either type the formula in every cell, but copy-pasting will be easier and more efficient.First, enter the formula =VLOOKUP (A2, Sheet2!$A$2:$D$7,3, FALSE) in cell C2, and press enter.The steps to perform the VLOOKUP function are as follows. We need to retrieve data of Column C from sheet2 to sheet 1.
#HOW TO USE VLOOKUP IN EXCEL FOR DIFFERENT SHEETS DOWNLOAD#
You can download this Vlookup from Another Sheet Excel?Template here – Vlookup from Another Sheet Excel?Template Vlookup from Another Sheet – Example # 1Īs we can see in example 2 above, additional columns are there, such as Columns C and D, when compared with sheet2. This column needs to be extracted in sheet1 from sheet2. Let us consider an example as shown in the below examples, where we have taken 2 worksheets wherein sheet1 there are names of players with its jersey numbers, but with missing runs scored columns. It returns an approximate match if the range lookup value is TRUE and returns exact matches if the range lookup is FALSE.Įxample of Vlookup from Another Sheet in Excel
![how to use vlookup in excel for different sheets how to use vlookup in excel for different sheets](https://www.benlcollins.com/wp-content/uploads/2019/01/vlookup-multiple-criteria.jpg)
The lookup tables for each category are on separate sheets as shown below. The discount applied depends on the product category: A, B or C and the quantity purchased. We have at database of purchases to which we need to apply a discount.