Best way to lookup payroll records

[serraostudent1]

Each payweek I receive about 600 records some with duplicat names if an ee works overtime. I then look at previous payroll and extract a given account code. Because some ee's work overtime the rows do not always synchronize in count or names.

Any suggestions on the BEST lookup function? Or BEST tool? Is access a more logical option?

 

[dispelthemyth]

without the data it will be hard to advise

Please can you give an example of the data, obviously not real data just made up