Excel VLOOKUP

In my original thread I had a database that was only about 1600 lines. The orginal file worked fine when I made the suggested correction of converting the column to numbers. I now have a much larger database to work with, consisting of over 49000 lines. I need to confine the array to be between, Sheet2!A2:Sheet2!D2649.

I am listing two lines, the first works, the second does not, They both gave the required result in the first file.

Works:
=VLOOKUP($A2,Sheet2!A2:Sheet2!D2649,2,FALSE)

Result: Cover Assy, Tank, Solution Fill

Doesn't work:
=VLOOKUP($A13799,Sheet2!A13799:Sheet2!D16446,2,FALSE)

Desired Result: FAN, VACUUM, 5.1D, 120VAC, 1 STAGE [TF]
Result given: #N/A

I notice that the array searches progressively, thus searching for data where there would be non. How can I restrict this search?

I have tried the $ correction suggested, but the problem is that the search progresses column and line past the area where the data is located. Say the data in sheet 1 is listed at A13799, and in sheet 2 that same data is located at A1650, the VLOOKUP (as it progresses from A3 down only searches accordingly on sheet 2) SO, the data I am searching for, is before where the VLOOKUP is looking at sheet 2. I need my search to be restricted to just one area, and not grow with every line in sheet 1.

I have one page of data that is a complete list. I then have a second page of data that is the available list. I need list A to pull the matching data from list B, and make one row of correlated information.

I have attached part of the file. The whole file is too large to upload.

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?

Thank You ChemistB THAT is the answer... I was wanting to anchor the search. Once that was done, the appropriate data matched, and I could move to the next column making minor changes, and the formula continued to work. Now when I get my next three databases, I should be able to make it all match.

Thank You Bonny, and ChemistB for helping me understand the subtle changes I needed to make, for this to work.