Use INDEX and MATCH Formula in Excel November 30, 2019 =INDEX(C3:E11,MATCH("Frantz",B3:B11,0),2) References https://exceljet.net/index-and-match Related