Need help for multiple criteria vlookup

[Penny Bangalore]

Hi Folks,

Need your help to to build a formula for multiple criteria. so below is what i can explain my best.

i have my data in sheet 3 as below

Date					Date					Date					Date
5/1/2015					5/2/2015					5/3/2015					5/4/2015
Name	productivity	hours	Review		Name	productivity	hours	Review		Name	productivity	hours	Review		Name	productivity	hours	Review
user 1	506	6	85		user 1	190	179	122		user 1	225	229	292		user 1	567	508	517
user 2	563	4	35		user 2	101	187	111		user 2	248	300	251		user 2	552	547	532
user 3	429	9	76		user 3	199	102	101		user 3	300	211	279		user 3	527	523	506
user 4	742	6	27		user 4	173	132	187		user 4	211	272	224		user 4	592	553	572
user 5	166	8	94		user 5	185	137	130		user 5	251	256	259		user 5	505	593	513
user 6	636	9	86		user 6	175	145	148		user 6	250	231	285		user 6	593	564	556
user 7	209	6	26		user 7	176	106	140		user 7	274	235	251		user 7	585	523	514
user 8	741	7	87		user 8	126	116	181		user 8	296	292	227		user 8	526	500	585
user 9	453	7	83		user 9	126	190	127		user 9	227	266	285		user 9	550	567	518
user 10	384	2	20		user 10	122	102	107		user 10	272	256	290		user 10	566	558	597
user 11	749	1	36		user 11	118	140	159		user 11	249	300	280		user 11	562	578	558
user 12	507	5	69		user 12	129	116	190		user 12	261	289	295		user 12	578	527	527
user 13	328	4	11		user 13	133	197	110		user 13	224	295	228		user 13	522	508	568
user 14	618	1	85		user 14	199	143	197		user 14	205	296	275		user 14	574	585	562
user 15	539	7	46		user 15	112	138	174		user 15	267	217	225		user 15	560	562	585
user 16	410	10	44		user 16	189	158	167		user 16	202	300	251		user 16	576	534	578
user 17	218	3	25		user 17	107	192	171		user 17	258	291	236		user 17	530	579	545
user 18	286	3	74		user 18	117	116	160		user 18	241	224	280		user 18	579	561	597

<tbody>
</tbody>

what i need is in sheet 2 is the productivity and review and hour counts based on date and user in below format

User 1

User 1

User 1

User 1

Date

productivity

hours

review

productivity

hours

review

productivity

hours

review

productivity

hours

review

5/1/2015

5/2/2015

5/3/2015

5/4/2015

5/5/2015

5/6/2015

5/7/2015

5/8/2015

5/9/2015

5/10/2015

5/11/2015

5/12/2015

5/13/2015

5/14/2015

5/15/2015

5/16/2015

5/17/2015

5/18/2015

5/19/2015

5/20/2015

5/21/2015

5/22/2015

<tbody>
</tbody>

some one please help me with a multiple criteria vlookup.some one please help me with a multiple criteria vlookup.

 

[Penny Bangalore]

Hi Vector,

thanks for you time, i guess dsum actually adds my criteria .. but i need vlookup with multiple criteria which can match user and date..

keeping my fingers crossed for better formula