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 :confused:
<tbody>
Home
Away
$50
True
Away
Home
Away
$75
True
Home
Home
Away
$100
True
Home...