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.