excel - Match corresponding records on different sheets -

for example: have 2 sheets, both matching columns, column , b same on both sheet. column on both sheets match, contain same value, column b may different, in example bellow. of data matches besides row 3. in sheet 1 has "c" in column b, in sheet 2 has "f" in column b.

what trying have column shows if match or not, in example, row 1, 2 , 4 have "match", row 3 "mismatch" , trying have on separate sheet (sheet 3).

i think vlookup best bet, have no idea start. appreciated.

sheet 1:

columna | columnb

1 |

2 | b

3 | c

4 | d

sheet 2:

columna |columnb

1 | a

2 | b

3 | f

4 | d

sheet 3:

columna |columnb

1 | match

2 | match

3 | mismatch

4 | match

if 2 lookup equal each other match, otherwise no match, in b1 of sheet3:

=if(vlookup(a1,sheet1!a:b,2,false)=vlookup(a1,sheet2!a:b,2,false),"match","mismatch") 

and copy down.