![how to use vlookup in excel sheet how to use vlookup in excel sheet](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Vlookup-another-workbook.png)
We can see that in a table, all values are matching the exact value.Īs above showing in the picture in the H column, there is employee age mention and column I employee name. So then we need to put the 0 for exact matching or 1 for false matching. Master data table b, as above showing, is a table array, and in master data, you can see that mobile no column is on the 5 number column index. So as the employee name is a unique column, then the employee names a lookup value in a table where you want to get a result. And you have another table where required only contact no of the employee. So you can suppose as array table or master table data. To search for an exact match, you put false in the last argument.Īs mentioned in table b, there is all employee information like department, employee id, address, mobile no, etc.
How to use vlookup in excel sheet download#
You can download this VLOOKUP Function Template here – VLOOKUP Function Template Example #1 – Exact Match Below mention are the details using the formulas. Let us understand the working of vlookup. Vlookup function is very simple and easy to use. We can also use one sheet to another sheet and one workbook to another workbook also. This function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index number position. When the user uses the vlookup function for finding specific information in an MS Excel spreadsheet, each matching information is displayed in the same row but in the next column. This function helps you to locate specific information in your spreadsheet. = vlookup (lookup value, table range, column index) > enter
![how to use vlookup in excel sheet how to use vlookup in excel sheet](https://www.exceldemy.com/wp-content/uploads/2018/05/vlookup-formula-to-compare-two-columns-10.png)
Put the col index number for another table vertical value which is a need.You need to put the table array, which is another table value.Put the lookup value where you want to match from one table to another table value.Then we have to enter the details as shown in the picture.We get a new function window showing in the below mention pictures.
![how to use vlookup in excel sheet how to use vlookup in excel sheet](https://i.ytimg.com/vi/h5abzTVqMiE/maxresdefault.jpg)
![how to use vlookup in excel sheet how to use vlookup in excel sheet](https://global-sharepoint.com/wp-content/uploads/2020/12/How-to-populate-values-in-excel-from-another-sheet-using-vlookup.jpg)