Matching Data

[Jordan12]

Hi

I am looking for some help please. only been coding for a few months now and only know basic. I am trying to match two sets of data in different sheets, sheet1 Col A = ref no, B = surname, C = int, etc, the same data on sheet 2.

Is there in way using vba to match the data in sheet 1 to sheet 2, like a vlookup.
I found this vlookup eg: =VLOOKUP(D2&E2,CHOOSE({1,2},D14:D27&E14:E27,F14:F27),2,0) that checks the columns in sheet1 to 2 and returns the value that I require and n/a if nothing matches. What I would like is to know if there is a way to do this check and finds a mismatch for eg the surname column it needs to tell me in which column the mismatch is eg check surname or check amount.
[TABLE="width: 551"]
<tbody>[TR]
[TD]
Thanks
Jordan[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col></colgroup>[/TABLE]