title: String comparison in Excel VBA
body: <p>There is a huge set of data in two columns. I have to print whether the two strings are matching or not into a third column as match/not match.</p>
  
  <pre><code>For example-  YES &amp; YeS match
                yes &amp; YES match
                ye2 &amp; yes No match &amp; so on
  </code></pre>
  
  <p>I have been doing this manually, checking values in each column then writing as match/no match. Would appreciate some help to make the process automated.</p>