Ranking Function According To Conditions

I want to rank the employee corresponding to their overall rate while satisfying two conditions. Below written is how database will look like with different departments and employee names. I want function should give the employee rank when I enter his/her name and department. Check below for graphical view:

ABCD1Employee NameOverall RateDepartment
2Andy1HR3Gary1.5HR4Rina1.67HR5Rose1.2HR6Mary1.7HR7Joe1.5HR8Rose2HS9Rose1IT10Dany1.9HS1112
Employee Performance 1314Search: Enter Folowing15Enter Employee Name:Andy16
Enter Department:HR17Employee Detail18NameAndy19DepartmentHR20
Overall Rate121Ranking within Dept.#REF!22Department Average1.43

When I enter employee name in c15 and department in c16 i get all the desired values apart from rank.The formula which I use for rank is as appended below:

{=RANK(INDEX(B2:B10,MATCH(1,(A2:A10=$C15)*(C2:C10=$C16),0),B2:B10),INDIRECT("IF(C2:C10=$C16,B2:B10)"),1)}

If i but the cell range as b2:b10 instead of INDIRECT("IF(C2:C10=$C16,B2:B10)") then it give rank by considering all the values in that cell range. My problem is how to define the desired cell range. which gives me rank for HR department only.