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”

user id	date	day	total hours worked
123	9/23/2019	mon	06:12:40
123	9/24/2019	tue	06:45:52
123	9/25/2019	wed	06:12:40
123	9/26/2019	thu	09:16:46
123	9/27/2019	fri	08:34:42
123	9/28/2019	sat	07:34:47
123	9/29/2019	sun	05:39:18

<tbody>
</tbody>

 

[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)),"")