Formula to look up 2 values and return 3rd value

Question

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 formula that matches the employee ID and date and then returns the scheduled job.

I know how to use vlookup to lookup the employee and return the scheduled job but not how to incorporate the date factor

twifoo · Answer

melanie2451&nbsp;I see no scheduled jobs in your attached files. Please ensure that such jobs are indicated therein, then attach your files again.&nbsp;

tauqeeracma · Answer

melanie2451&nbsp;Please refer the attached files just for the understanding purpose that how to incorporate date factor in vlookup. You may rearrange the columns accordingly.

melanie2451 · Answer

tauqeeracma&nbsp;Thank you for your assistance, it's greatly appreciated.

Forum Discussion

Formula to look up 2 values and return 3rd value

3 Replies