Index match excel Using the Index function, you have gathered the information about the 3rd seller Albert and how much he sold in February using the data from both row and column. The Match function provided you with information about a particular seller’s serial number. Now you can very easily combine Index and Match function in a single formula and gather the information about how much the 5th seller sold in June following the picture below.=INDEX(C4:E8,MATCH(“Stuart”,B4:B8,0),3)