EXCEL FORMULA

Hi Excel Experts,   Please help me regarding on this excel formula. I want to select a text in match table (highlighted yellow) to show the result in result table. Kindly see the picture and attach...