title: Two almost exact lists: If the column at the right have a specific value, then copy it at the left (excel)
body: <p>I am working with excel.</p>
  <p>I have almost two identical columns and I need some of the different results of the column at the right to be at the column at the left.</p>
  <p>They look like this....</p>
  <pre><code>A      B
  Yes    Yes
  No     No
  No     Maybe
  Yes    Yes
  Yes    Maybe
  No     NA
  Yes    Yes
  No     Maybe
  Yes    NA
  No     No
  </code></pre>
  <p>I need new column A that contains the &quot;Maybe&quot; and maintain the values of the A when is NA in the B column... So it should look like this....</p>
  <pre><code>A      B        C
  Yes    Yes      Yes
  No     No       No
  No     Maybe    Maybe
  Yes    Yes      Yes
  Yes    Maybe    Maybe
  No     NA       No
  Yes    Yes      Yes
  No     Maybe    Maybe
  Yes    NA       Yes
  No     No       No
  </code></pre>
  <p>I have tried different things with IF formula, Match formula and Vlookup formula, but I have not reach a solution.</p>