title: Excel concatenate with IF statement
body: <p>What I am trying to do is concatenate two cells, then check that concatenated value against a column of values, and put an X in a cell if such a value exists.  The following equation is what I'm using:</p>
  
  <pre><code>{=IF(CONCATENATE(A2, " ", B2) = 'MasterList'!$C:$C, "x", "")}
  </code></pre>
  
  <p>Column A is the name of the software and Column B the version number <code>(A="Microsoft .NET Framework 4.5.1", B="4.5.50938", for example).</code> I know that this concatenated value exists on the MasterList worksheet so I don't understand why I'm not getting the answer I expect.  </p>
  
  <p>Gurus, what's my flaw here?</p>