Vlookup - Sorting issues

[Wild Bill]

I have an Excel workbook that basically contains pointers to real data
in another workbook by use of vlookup

Like this:

ID | LastName | FirstName| Hours1 | Hours2 | etc

Column 1 Lookup value
Column 2 =VLOOKUP(A14,'Filename.xlsm'!AllHsk,2,FALSE)
Column 3 =VLOOKUP(A14,Filename.xlsm'!AllHsk,3,FALSE)
Column 4 =VLOOKUP(Hskp!A17,'Daily TS PPE #1.xlsm'!AllHsk,8,FALSE)

And so on
AllHsk the lookup range or table array for the data.

Whether I have this set up as a 2007 Table (preferrable) or a range,
if I sort on column 1, 2 and three will sort, but 4 does not sort
correctly. I don't think Hskp should make a difference.

Thanks in advance,
CFS