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 MICROSOFT EXCEL FORMULAS LIKEENGINEERS DO 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”.
![how to use microsoft excel formulas likeengineers do how to use microsoft excel formulas likeengineers do](https://img.yumpu.com/26356573/1/500x640/using-the-solver-add-in-in-microsoft-excel-chemical-engineering-.jpg)
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.
![how to use microsoft excel formulas likeengineers do how to use microsoft excel formulas likeengineers do](https://i0.wp.com/blogs.autodesk.com/revit/wp-content/uploads/sites/110/2019/12/Results-Connect-header.png)
Input data should be in the leftmost column and result data
![how to use microsoft excel formulas likeengineers do how to use microsoft excel formulas likeengineers do](https://post.edu/wp-content/uploads/2018/02/excel-tips-for-business.png)
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.