Hi, excel forum I know how to use index match. but what if the data is not neat

excel question.png

What function should I put in C15 to E19?