If I understand you right, Barbara, you want each cell in the tbl_Employee worksheet to look up a time from the EmployeeData worksheet where it matches the correct emp ID and date. Now, if it were me, I'd create on the EmployeeData worksheet a helping column concatenating the employee ID and the date, and then do an ordinary VLOOKUP up the concatenated data. But Pecoflyer has this neat trick he does with array formulae that will probably save you having to make the helping column; I haven't figured it all out yet, but I'll bet he'll be able to come up with something that'll work better than my idea.

I think I love you.

I have worked for hours, and I tried something similar, however, you simplified it for me...and Viola!!!

This worked:
=VLOOKUP(A2&B$1,[Check_IN.xls]EmployeeData!$A$3:$E$1257,5,FALSE)