Match corresponding records on different sheets
<p>For example: I have two sheets, both with matching columns, Column A and B are the same on both sheet. Column A on both sheets will always match, they will always contain the same value, but Column B may be different, like in the example bellow. All of the data matches besides row 3. In Sheet 1 it has "c" in column B, but in Sheet 2 it has "f" in column B. </p>

<p>What I am trying to do is have a column that shows if they match or not, so in the example, row 1, 2 and 4 would all have "match", but row 3 it would say "mismatch" and I am trying to have this all on a separate sheet (sheet 3).</p>

<p>I think Vlookup would be the best bet, but I have no idea where to start. Any help would be appreciated. </p>

<p><strong>Sheet 1:</strong></p>

<p>ColumnA | ColumnB</p>

<p>1 | a  </p>

<p>2 | b </p>

<p>3 | c</p>

<p>4 | d</p>

<p><strong>Sheet 2:</strong></p>

<p>ColumnA |ColumnB</p>

<p>1 | a</p>

<p>2 | b</p>

<p>3 | f</p>

<p>4 | d</p>

<p><strong>Sheet 3:</strong></p>

<p>ColumnA |ColumnB</p>

<p>1 | match</p>

<p>2 | match</p>

<p>3 | mismatch</p>

<p>4 | match</p>