Click on Kutools, select the formulas tab then click Look for a value in the list.ģ. Once you install the add-in to your excel workbook, put your cursor on the cell where the value is to be returned.Ģ. You can download a free trial Kutools add-in and use it to compare two columns and return the value in a third column.ġ. Use the fill handle to drag the formula to the rest of the cells you want to match. Using the same example, compare the projects in columns A and D and if a match is found, return the corresponding name in column B. You can pull the matching content from one column to another using the Index and match formulas only. In the above formulas, cell D2 is the criteria cell that returns a value based on column cells A2:A20 which is to be compared with and return the matching value from data range A2:B20. Autofill the formula to the rest of the cells Copy the formula to the rest of the cells using the Autofill feature or drag the fill handle down to the cells you want to copy the formula.ġ. Press ENTER key to get the matching content on the E2.Ĥ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |