Dual VLookup Formula

[rizmomin]

Hello:

Please refer to attached file.
Sheet1 from Column AM thru AV has clockIn-Clockout info and Column AW has total hours worked
for a single day.

Sheet2: Name of Employee is in Cell K7
I need formula in cell K12:S18 to bring ClockIn-ClokOut data from Sheet1 for employee in Cell K7 Sheet2.



Let me know if you have any questions.
Thanks.

Riz

[Ace_XL]

In K12

=SUMIFS(Sheet1!AO:AO,Sheet1!$AN:$AN,$K$7,Sheet1!$AM:$AM,$I12)

Copy down and across

Format cells Except Column S as h:mm;;

[rizmomin]

Hi Ace_XL:

Seems to work great, will test more and will let you know if further help is needed.

Thanks a lot..

Riz