vlookup help

[bigmac1]

Hello all, can you help please, I have inherited a workbook to look after, it has a sheet called “TIMESHEET” and one called” FINGER PRINT LOOKUP” first on has the following columns, date, user id, and finger print hours worked. last sheet records user id, in, out, and total time. (there are other columns on each sheet but not holding information relevant to this issue).
I need to run a vlookup to look at the date column (2) on “TIMESHEET” and match it to the date column (8) on” FINGER PRINT LOOKUP” BUT also look at the user id on both sheets and match them so I will end up with the following on “TIMESHEET”
[TABLE="width: 312"]
<tbody>[TR]
[TD]user id
[/TD]
[TD]date
[/TD]
[TD]day
[/TD]
[TD]total hours worked
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]9/23/2019
[/TD]
[TD] mon
[/TD]
[TD]06:12:40
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]9/24/2019
[/TD]
[TD] tue
[/TD]
[TD]06:45:52
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]9/25/2019
[/TD]
[TD]wed
[/TD]
[TD]06:12:40
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]9/26/2019
[/TD]
[TD]thu
[/TD]
[TD]09:16:46
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]9/27/2019
[/TD]
[TD]fri
[/TD]
[TD]08:34:42
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]9/28/2019
[/TD]
[TD]sat
[/TD]
[TD]07:34:47
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]9/29/2019
[/TD]
[TD]sun
[/TD]
[TD]05:39:18
[/TD]
[/TR]
</tbody>[/TABLE]

 

[RasGhul]

Hi,

Assuming that the total hours worked is from column 4 & user ID is column 1 on the finger print lookup sheet.

This worked for me, adjust the ranges as needed;

=IFNA(INDEX('FINGER PRINT LOOKUP'!$D$2:$D$8,MATCH(TIMESHEET!A2&TIMESHEET!B2,INDEX('FINGER PRINT LOOKUP'!$A$2:$A$8&'FINGER PRINT LOOKUP'!$H$2:$H$8,),0)),"")