IF, INDEX & MATCH formula

[Steviefiege]

Hi,

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

These are my players & positions:

<tbody>
[TD="class: xl65"]Kongolo, Rodney[/TD]
[TD="class: xl63, width: 141"]Advanced Playmaker[/TD]
[TD="class: xl68, width: 64, align: right"][/TD]

[TD="class: xl66"]Kongolo, Rodney[/TD]
[TD="class: xl64"]Attacking Midfielder[/TD]
[TD="class: xl68, align: right"][/TD]

[TD="class: xl65"]Kongolo, Rodney[/TD]
[TD="class: xl63"]Advanced Playmaker2[/TD]
[TD="class: xl68, align: right"][/TD]

[TD="class: xl67"]Lawlor, Ian[/TD]
[TD="class: xl64"]Goalkeeper[/TD]
[TD="class: xl68, align: right"][/TD]

</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.