Column C1= $125, $100 or $75 AND D1 = TRUE then this cell = A1, if not then it is blank. But also if column C1 = $50 and D1 = TRUE then this cell = B1.
Not sure how to get this formula to work
[TABLE="width: 500"]
<tbody>[TR]
[TD]Away[/TD]
[TD]Home[/TD]
[TD]$50[/TD]
[TD]TRUE[/TD]
[TD]Home[/TD]
[/TR]
[TR]
[TD]Away[/TD]
[TD]Home[/TD]
[TD]$75[/TD]
[TD]TRUE[/TD]
[TD]Away[/TD]
[/TR]
[TR]
[TD]Away[/TD]
[TD]Home[/TD]
[TD]$100[/TD]
[TD]TRUE[/TD]
[TD]Away[/TD]
[/TR]
[TR]
[TD]Away[/TD]
[TD]Home[/TD]
[TD]$125[/TD]
[TD]TRUE[/TD]
[TD]Away[/TD]
[/TR]
[TR]
[TD]Away[/TD]
[TD]Home[/TD]
[TD]$100[/TD]
[TD]FALSE[/TD]
[TD]-[/TD]
[/TR]
</tbody>[/TABLE]
Not sure how to get this formula to work
[TABLE="width: 500"]
<tbody>[TR]
[TD]Away[/TD]
[TD]Home[/TD]
[TD]$50[/TD]
[TD]TRUE[/TD]
[TD]Home[/TD]
[/TR]
[TR]
[TD]Away[/TD]
[TD]Home[/TD]
[TD]$75[/TD]
[TD]TRUE[/TD]
[TD]Away[/TD]
[/TR]
[TR]
[TD]Away[/TD]
[TD]Home[/TD]
[TD]$100[/TD]
[TD]TRUE[/TD]
[TD]Away[/TD]
[/TR]
[TR]
[TD]Away[/TD]
[TD]Home[/TD]
[TD]$125[/TD]
[TD]TRUE[/TD]
[TD]Away[/TD]
[/TR]
[TR]
[TD]Away[/TD]
[TD]Home[/TD]
[TD]$100[/TD]
[TD]FALSE[/TD]
[TD]-[/TD]
[/TR]
</tbody>[/TABLE]