title: How to use If statement to transfer a cell value from sheet1 to sheet 2 in Google Sheets?
body: <p>I just want to know if its possible to use the <code>IF</code> STATEMENT in Google Sheets by such algorithm as follows;</p>
  <p>On Sheet1, from Cell <code>A1</code>, I have a value <code>blue</code>, and if the value inside the cell is <code>blue</code>, it should be transferred in Sheet2, I don't know if the syntax is correct, but it's something like this.</p>
  <pre><code>=if A1 VALUE(Blue) then TRANSFER to sheet2 else FALSE;
  </code></pre>
  <p>Just to interpret how should it work, but I know the code is wrong. Any help will be greatly appreciated guys.</p>