Steviefiege
Board Regular
- Joined
- Aug 29, 2018
- Messages
- 66
Hi,
I have a formula in a cell C: =IF(T3<>"","",S3)
These are my players & positions:
<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.
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.
Last edited: