Hi There,

If the data you need is just between Sheet2!A2:Sheet2!D2649 then why dont try this and drag it till your requirements. The "$" sign before the column name and row number would fix the column and row of your search


=VLOOKUP($A2,Sheet2!$A$2:Sheet2!$D$2649,2,FALSE)

drag it till your requirements