# Lookup/Index/Match - Mulitple Criteria help.

#### Godber

##### New Member
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>
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>

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
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))

Excel 2010
ABCDE
1Agent NameDataLogin I.D.Staffed TimeStaffed Time Helper)
2
3
4Jim MayJims Data11/27/2013
Summary
Cell Formulas
RangeFormula
E4=SUMPRODUCT(--(Data!\$A:\$A=Summary!A4),--(Data!\$B:\$B=Summary!B4),Data!\$D:\$D)

Excel 2010
ABCD
1Col1Col2Col3Col4
2
3
4Jim MayJims Dataalsdkf11/27/2013
Data

Replies
0
Views
204
Replies
4
Views
329
Replies
8
Views
236
Replies
4
Views
428
Replies
12
Views
1K

1,203,690
Messages
6,056,755
Members
444,889
Latest member
ibbara

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back