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.
<tbody>
</tbody><colgroup><col><col><col><col><col><col></colgroup>
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.
Thanks Jordan | |||||
<tbody>
</tbody><colgroup><col><col><col><col><col><col></colgroup>