Hello Wurugu


i can't also get your idea but i've notice your

 
=VLOOKUP(A2,Sheet1!A1:B45,2)
should be with $ like

=VLOOKUP(A2,Sheet1!A$1:B$45,2)
then drag down maybe this is what you wanted.

HTH.