![]() Now, if you need to know all the values that match, simply apply a filter and only show all the TRUE values. Thank you for reading this step-by-step guide to using INDEX MATCH in Excel. Below is a simple formula to compare two columns (side by side): A2B2 The above formula will give you a TRUE if both the values are the same and FALSE in case they are not. Hopefully, this short video made it even clearer how to use the two functions to dramatically improve your lookup capabilities in Excel. Video Explanation of How to Use Index Match in Excelīelow is a short video tutorial on how to combine the two functions and effectively use Index Match in Excel! Check out more free Excel tutorials on CFI’s YouTube Channel. Congratulations, you now have a dynamic INDEX MATCH formula!.Cut the MATCH formula for Height and replace the “2” with it.Cut the MATCH formula for Kevin and replace the “4” with it.Now we can take the two MATCH formulas and use them to replace the “4” and the “2” in the original INDEX formula. The result is that Height is in column “2.”.Select all the cells across the top row of the table.Type “=MATCH(” and link to the cell containing “Height”… the criteria we want to look up.Use MATCH again to figure out what column Height is in. The result is that Kevin is in row “4.” If you have two lists that should be identical, but you suspect they might not be, you can put in a simple formula that sets one cell equal to another.Select all the cells in the Name column (including the “Name” header).Type “=MATCH(” and link to the cell containing “Kevin”… the name we want to look up.Sticking with the same example as above, let’s use MATCH to figure out what row Kevin is in. Type the column number for Height, which is “2,” and close the bracket. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |