title: IF statement that will let me input values from a single cell
body: <p>I need to look through column C and search for a text "TF06" and if that's true I need to replace the corresponding row in column D to the specific input FROM cell F2.</p>
  
  <p>This is as far as I can get. Here is my code:</p>
  
  <pre><code>=IF((VLOOKUP("TF06", C2:D54, 2, FALSE)), REPLACE(ROWS(VLOOKUP("TF06", C2:D54, 2, FALSE)), 1, 1, F2), 0)
  </code></pre>