Touff_One_Not able to find suitable formula

[chandrajitshahkumar]

Name	Test Type	Marks
Priyanka <tbody> </tbody>	Unit Test <tbody> </tbody>	91 <tbody> </tbody>
Prakash <tbody> </tbody>	Unit Test	85
Rani <tbody> </tbody>	Unit Test	75
bablu <tbody> </tbody>	Unit Test	65
Rajesh <tbody> </tbody>	Unit Test	86
Manish <tbody> </tbody>	Unit Test	69
Priyanka	Mid Test <tbody> </tbody>	82
Prakash	Mid Test <tbody> </tbody>	75
Rani	Mid Test <tbody> </tbody>	64
bablu	Mid Test <tbody> </tbody>	59
Rajesh	Mid Test <tbody> </tbody>	66
Manish	Mid Test <tbody> </tbody>	92
Priyanka	Final Test <tbody> </tbody>	82
Prakash	Final Test <tbody> </tbody>	83
Rani	Final Test <tbody> </tbody>	81
bablu	Final Test <tbody> </tbody>	78
Rajesh	Final Test <tbody> </tbody>	79
Manish	Final Test <tbody> </tbody>	90

<tbody>
</tbody>

Use one formula which will fill up the box according to the above table in which test type, marks and student name is mentioned.
Marks should be appropriate according to the student name and test type

<tbody> </tbody>	Unit Test	Mid Test	Final Test
Priyanka <tbody> </tbody>
Prakash <tbody> </tbody>
Rani <tbody> </tbody>
bablu
Rajesh <tbody> </tbody>
Manish <tbody> </tbody>

<tbody>
</tbody>

 

[chandrajitshahkumar]

Thank you this is also working

 

[chandrajitshahkumar]

L. Howard thank you your formula is also working thanks a lot. I know you all are elder than me so respectly thank you SIR