Traceelewis71
New Member
- Joined
- Dec 5, 2017
- Messages
- 12
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
<tbody>
</tbody>
<colgroup><col span="2"><col span="2"></colgroup><tbody>
</tbody>
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>