In this case, the MATCH function will return the relative position of a value in employee name-2. So the MATCH function returns the relative position of data in the selected array that matches a certain value in a specified order. Additionally, we will be using the same dataset as the first method. Secondly, we can use the INDEX and MATCH functions to perform the same task of matching two columns and returning a third in Excel. How to Match Two Columns and Return a Third in Excel using the INDEX and MATCH Functions And tada! We have successfully matched two columns and returned a third in Excel using the VLOOKUP function. Secondly, we will drag down the Fill Handle tool to copy the formula and apply it to the rest of the cells.ģ. Lastly, we will press the Enter key to return the value.Ģ. Then, we will type in the formula “ =VLOOKUP(E2,$B$2:$C$10,2,FALSE)”. Firstly, we will create a new column beside Employee Name-2 to place the returned third column. To do this method, we can follow the steps below.ġ. Lastly, it will return the corresponding department of the employee. Then, it will look for a match in the selected array, which is the employee name column. So the VLOOKUP function will take a value from employee name-2 as the lookup value. Let’s say we have the same dataset from the sample scenario, which contains the employee name and department. How to Match Two Columns and Return a Third in Excel using the VLOOKUP Functionįirstly, we will utilize the VLOOKUP function to match two columns and return a third in Excel. Great! Now we can explain how to match columns and return a third in Excel using three simple and easy methods. If omitted, the row_num argument is required. Similarly, this will select the column in the array from which to return a value. When this is omitted, we need to input the column_num argument. And this will select the row in the array from which to return a value. So it refers to a range of cells or an array constant we select. And this function is used to return a value or cell reference at the intersection of a specific row and column based on the given range.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |