#How to use vlookup in excel youtube code

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 youtube 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.