VLOOKUP problem

[CycloneBrian]

I have a table that has different names in left column with numbers relating to that name in columns B-Z for years 1986-2011 in Sheet 2.

On a seperate sheet I have a box where a formula populates the name. "Franklin" is the name currently in the reference cell (B$5).

If I enter VLOOKUP(B$5,Sheet 2 range,2,FALSE) then I get a #N/A

If I enter VLOOKUP(B$5,Sheet 2 range,2) than I get the data for the cell above Franklin.

**where Sheet 2 range is actually specific to the range of data

I have made sure I don't have any spaces in either one of the inputs or the table and can't get past this. Anybody know what I am doing wrong?