IF, INDEX & MATCH formula

[Steviefiege]

Hi,

I have a formula in a cell C: =IF(T3<>"","",S3)

These are my players & positions:

Kongolo, Rodney	Advanced Playmaker
Kongolo, Rodney	Attacking Midfielder
Kongolo, Rodney	Advanced Playmaker2
Lawlor, Ian	Goalkeeper

<tbody>
</tbody>

In cell C, i want to add to that formula to say if the position is a goalkeeper to look into another 2 cells (Which are on another sheet) & find that particular player & his rating & put the rating in cell C. If the position is not a goalkeeper then carry on as the original formula.

 

[Jeffrey Mahoney]

=IF(T3<>"","",IF(B3="GoalKeeper",SUM(Sheet2!C8:D8),S3))

Imbedded IF statement. You, of course will change the blue part to reflect the formula that you need.