To begin, sorry about the upload. When I copied part of the file, pasted in a new one to make it short enough to upload is screwed it all up.

The term partial was used because I was limited to the size of file that I could upload, and I didn't want it confused with what I am working on.
Realize that the file is 49000 lines long on sheet 1

Sheet 2 contains the data I want to search

Cell K2 of the file I am working on contains the formula =VLOOKUP(A2,Sheet2!$A2:Sheet2!$D2649,2,FALSE)
This returns the desired answer

random cell in column K shows a formula of =VLOOKUP($A57,Sheet2!$A57:Sheet2!$D2704,2,FALSE)
Which, you can see, no longer begins it's search at sheet2!A2
It Begins the search at sheet2!A57

I need the search to be confined, and not grow progressively so that the search perameters are kept, even at line 48999

I have fixed a couple of lines close to that limit, and refined the array to reflect the data I want searched, and got the answer I desired, but if I copy/paste the formula to the entire column, cell by cell, it changes.

Example of what worked:
=VLOOKUP($A13799,Sheet2!$A2:Sheet2!$D2649,2,FALSE)

Returned the description that matched

HOWEVER, the line above it was not corrected, and did NOT return a result -

Example
=VLOOKUP($A13798,Sheet2!$A13798:Sheet2!$D16445,2,FALSE)


So, do I go line by line, 49000 times and correct the search array?