Hi there, i have this problem when using the match function. I got two different workbooks, A and B. The former has fewer row of data than the later. So I used match function on A in order to find matching row number. Each row in A matched with B until at the 1033th position, the row number returned was supposed to be the same which is 1033 but I got 1034 instead. Sorry for my English, hope you guys understand. Thx.

Please post your sheet ( click Go advanced - manage attachments). Thanks

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post