Index match

[Traceelewis71]

I dont know what ive done wrong to my index match statement. I need to get monthly earning into a column. each person has 12 months in a row. On a separate spreadsheet I have the dollar amounts per month for each person. I need an index match statement that will put the 9.50% in the column. please help

Month	9.50%	Person ID
1	?	A02257
2		A02257
3		A02257
4		A02257
5
6
7
8
9
10
11
12

<tbody>
</tbody>

Month	person ID	9.5% of Gross
1	A02257	89.63
2	A02257	84.59
3	A02257	85.19
4	A02257	94.59
5	A02257	82.33
6	A02257	95.16
7	A02257	89.98
8	A02257	86.88
9	A02257	95.16
10	A02257	82.75
11	A02257	82.75
12	A02257	91.02

<colgroup><col span="2"><col span="2"></colgroup><tbody>
</tbody>

 

[Marcelo Branco]

Assuming the data are in Sheet2 columns A:C, headers in row 1, maybe this array formula in Sheet1 B2 copied down

=IF(C2="","",INDEX(Sheet2!C$2:C$100,MATCH(1,IF(Sheet2!A$2:A$100=A2,IF(Sheet2!B$2:B$100=C2,1)),0)))
confirmed with Ctrl+Shift+Enter, not just Enter

Or

Regular formula in B2 copied down
=IF(C2="","",SUMIFS(Sheet2!C:C,Sheet2!A:A,A2,Sheet2!B:B,C2))

M.