Lookup/Index/Match - Mulitple Criteria help.

[Godber]

Hi,<o></o>
<o> </o>
I appreciate that there are numerous threads around thisissue however I cannot get them to fit my situation.<o></o>
<o> </o>
Basically I have 2 sheets, a summary sheet and a data sheetthat gets raw data extracted to it from another program.<o></o>
<o> </o>
I have already set this spread sheet up for another purposeand now I need to tweak it to fit what I need.<o></o>
<o> </o>
The data returns a person’s statistics numerous times rowafter row, each row represents a different date.<o></o>
<o> </o>
What I want on my summary page is a way to pull through thecorrect data for the person and the correct date as a vlookup will just lookfor the person and return the same data on each row.<o></o>
<o> </o>
So column names on the summary sheet are as follows.<o></o>
<o> </o>
A: Agent Name<o></o>
B: Data<o></o>
C: Login I.D<o></o>
D: Staffed time (formatted)<o></o>
E: Staffed time (Helper column)<o></o>
<o> </o>
What I want to do is in cell E5, I want it to look at thecriteria A5 and B5 and then return the value from the second sheet which willbe Data!D4<o></o>
<o> </o>
A5 and B5 of the summary sheet are the same as A4 and B4 inthe Data sheet.<o></o>
<o> </o>
Hope I have made sense and provided all the info.<o></o>
<o> </o>
I hope someone can help me, I’m pulling my hair out!!<o></o>
<o> </o>
Thanks.<o></o>
<o> </o>
Liam<o></o>

 

[smkyle]

Here is one way to do it. Create a new column on the data sheet. F2 = A2&B2
Then on the first sheet E2 = INDEX($D$2:$D$999, MATCH(A2&B2, $F$2:$F$999, 0))

 

[jim may]

Excel 2010
	A	B	C	D	E
1	Agent Name	Data	Login I.D.	Staffed Time	Staffed Time Helper)
2
3
4	Jim May	Jims Data			11/27/2013
Summary

Cell Formulas
Range	Formula
E4	=SUMPRODUCT(--(Data!$A:$A=Summary!A4),--(Data!$B:$B=Summary!B4),Data!$D:$D)

Excel 2010
	A	B	C	D
1	Col1	Col2	Col3	Col4
2
3
4	Jim May	Jims Data	alsdkf	11/27/2013
Data