Formula to look up 2 values and return 3rd value

I have a workbook that contains timesheet entries for employees on certain dates.  I have another workbook that contains the job the employee was scheduled to work on certain dates.  I need a lookup ...