=VLOOKUP(F4,Sheet2!A:U,2,0) from you give this and =VLOOKUP(F4,Sheet2!A:U,3,0) this to see, has been incremented by a column, you said you have used the column function, this is to drag to the right to be incremented, and the second, you do not have to add the first parameter of the absolute reference or relative reference. Is it possible that the first parameter appears to change when you pull!
Alternatively, the third parameter can also be used with the match function, in the form of a larger or two forms of the columns are not one-to-one correspondence between the use of the match function can save the number of columns of the trouble
.