title: Display value based on condition - Excel
body: <p>I am trying to update one of the columns in the screenshot shown below based on a condition referring to counter column (Column F).</p>
  
  <p>For example, if counter = 0, then column G should be blank, else it should take value from appointment column from the above cell.</p>
  
  <p>Referring to the image below, 
  Cell G2 will be blank since counter = 0
  Cell G3 should display value from B2 and H3 shall display C3
  Cell G7 shall display should display value from cell B6 as they are all link to the same load (cell A6 has the load number)
  Similarly cells G8 - G10 should also display value from B6.</p>
  
  <p><a href="https://i.stack.imgur.com/dqj6m.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dqj6m.png" alt="enter image description here"></a></p>
  
  <p>Could anyone help me with the excel formula for the same. Thanks in advance.</p>