Learn how to get column and row intersection using index and match function. I will be providing a very detail explanation on how to use INDEX and MATCH function to get the column and row intersection data. <br /><br />Row-Column Intersection Data <br />Using INDEX and MATCH <br /><br />=INDEX(C3:I10,MATCH(B17,B3:B10,0),MATCH(C16,C2:I2,0)) <br /><br />Lets break this formula down. <br /><br />1) INDEX(C3:I10, ...) tells Excel to look within the range of cells C3 to I10. This is the table from which we want to retrieve a value. <br />2) MATCH(B17,B3:B10,0) is the first MATCH function. It looks for the value in cell B17 within the range of cells B3 to B10. The "0" at the end specifies an exact match. This function finds the row number in which the value in B17 is located within the B3 to B10 range. <br />3) MATCH(C16,C2:I2,0) is the second MATCH function. It looks for the value in cell C16 within the range of cells C2 to I2. Again, the "0" at the end specifies an exact match. This function finds the column number in which the value in C16 is located within the C2 to I2 range. <br /><br />The INDEX function then takes the table (C3:I10), the row number (found by the first MATCH function), and the column number (found by the second MATCH function), and returns the value located at the intersection of that row and column. <br /><br />So, in plain English, this formula is saying: "Look in the table C3:I10, find the row where the value in B17 matches the values in the range B3:B10, and find the column where the value in C16 matches the values in the range C2:I2. Return the value at the intersection of that row and column." <br /><br /><br /><br />Which function is used to fetch value by intersection of row and column?,How do I find the intersection of a row and a column in Excel?,INDEX and MATCH in Excel, <br />How do you INDEX match multiple results horizontally?,How do you use INDEX match vertical and horizontal?,Can you INDEX match with 3 criteria?, <br />
