Sorting with VLOOKUP

[spookralls]

I am working on a spreadsheet to track employee attendance.
Cell A is the employee ID number, Cell B is the employee (=VLOOKUP(A573,$N$3:$P$131,2,FALSE), and Cell C is the position (=VLOOKUP(A671,$N$3:$P$131,3,FALSE).
In cell E I have the date of the occurrence. When I attempt to sort by date the data gets out of order. Is there any way to sort by date without causing the data to be misplaced?

1	Employee 1	Cashier		11/1/2024	ci2	2		1.45597
2	Employee 2	Cashier		11/15/2024	t2w	1		2.45611

 

[KillerOfGiants]

Assuming you are just using the sort function under the Data menu: It appears that columns D and H are blank columns? It's possible that you don't have the entire range of information selected, so it's only sorting columns E, F, and G. Would otherwise need more information.