- #How to use vlookup in excel for names how to#
- #How to use vlookup in excel for names code#
- #How to use vlookup in excel for names plus#
#How to use vlookup in excel for names plus#
Next, we use the fill handle tool (the small plus sign found at the bottom of Cell C5 ) to drag the formula from Cell C5 to Cell E11įigure 7- Result of using the VLOOKUP and INDIRECT functions Explanation.We will enter the formula below on Cell C5.To lookup data, we will pick a cell in the sheet: budlog ”, assign the VLOOKUP formula and extract the data by creating a dynamic reference to the sheet name for the Budget sheet.Īpplying the VLOOKUP and INDIRECT function.We will set up our hypothetical list of data titled Groceries in Columns B.In this sheet, we will enter the following names in Cells C4 to E4, “wk1”, “wk2 ”, and “ wk3.We will create a 4th sheet, titled “ Budlog.We will create identical sheets with different values for the quantity section as found in the “ Wk1 ” in sheets Wk2, and Wk3 respectively.In this sheet, we will set up our hypothetical data titled “Groceries” and “Quantity” in Columns B and C as displayed in the figure below.We will assign a name to the blank sheet called “ Wk1.
#How to use vlookup in excel for names how to#
With the following illustrations, we will learn how to use these functions in simple steps.įigure 1- Results of using the Excel VLOOKUP and INDIRECT function General Formula Here, we can see that Raju’s phone number is not there in the list therefore the result is not found instead of error #N/A.We can apply the VLOOKUP and INDIRECT functions to look up data in a variable sheet name in Excel. We can replace error #N/A with “not found”. Suppose if you want to search the phone number of “Raju” but in the given list Raju’s phone number is not there then VLOOKUP formula will show the error #N/AĬan use “iferror” function to replace the error message with useful It will not show the result of the second name as highlighted in “2”. Suppose if you want to search the phone number of “Nalini” then VLOOKUP function will search the first result only as highlighted in “1”. Then VLOOKUP is an efficient tool or formula to perform the task Syntax will look like =VLOOKUP(F3,C2:D13,2,0)Ģ: Indicates the column in which phone number is presentĠ: Indicates the exact match Advantages of VLOOKUP :įile with thousands of columns in it and you want to search for particular data Step4: Select the option between approximate match and exact match.
In the given table name column is column no 1 and the phone number column is Table you have to specify the column number in which the phone number is there.
#How to use vlookup in excel for names code#
In the given table you can see that theįirst column is Employee code but we have to select the table from name column i.e. Select the table in such a way that the firstĬolumn should be the name of the person. Step2: Select the table in which we have to search Name of the person in F3 cell, therefore select the cell F3.
Type the name of the person in an inverted comma for example: “Nalini”. Step1: Select the name of the person or you can also Use function or formula =VLOOKUP(F3,C2:D13,2,0) Example: Search the phone number of “Nalini” Select the “exact match option or put 0”. It not necessary that it should be theĬol_index_num: In this, you have to mention the column in whichīetween approximate match and exact match. Should be on the right side of that column. Input data should be in the leftmost column and result data Table_array: You have to select the table in which you have to Lookup_value: This function means, enter the data or select theĭata for which you want to search the related data. This function scans the data in the left-most column and finds the result corresponding to the right of that cell. VLOOKUP formula or VLOOKUP function can reduce the work time by 80-90%. VLOOKUP formula is a very important tool and widely used in data analysis and day to day activities in office and businesses.
0 kommentar(er)
