I seem to be having trouble with my vlookup formula not retreiving all of the
requested data for an array of cells.

I enter my vlookup as usual, select the array of cells in another workbook
as usual, and when I copy the formula down, it returns #N/A for a few of the
cells located at the bottom of the list. I then gather all of cells with
missing information that the vlookup formula failed to gather, enter the same
formula for the same array of cells, and this time, the formula gathers a
little more information that it missed from the last time. I have to keep
sorting and entering in a new formula until all information is retrieved.

Any help is appreciated. Thank you.
--
-Nick