Alex_Excel
New Member
- Joined
- Apr 9, 2015
- Messages
- 7
Hello,
I'm having trouble with my index formula..
Situation:
First table is data, second table is calculation
column
A B C D
Table range is A2:D6
<tbody>
</tbody>
The second table comes from these formulas:
<colgroup><col span="2"><col span="2"></colgroup><tbody>
</tbody>
PROBLEM is: I get the same values for D and C in column A!!
How do I add an extra criteria so the result looks like the first table but only with formulas?
Extra: right now there is 2 times the letter D in column A. The number of times this value D appears in the column can change over time, the column is always sorted A-Z so all the values D will show under each other. Right now it's A3:A4 that contains the D, but if more D are added then the 4 will expand. Is it possible to include this in the answer please?
Same goes for C ofcourse ^^
Thank you!!
Much obliged,
Alex
I'm having trouble with my index formula..
Situation:
First table is data, second table is calculation
column
A B C D
Table range is A2:D6
GSSE | GTRS | ||
D | 70417 | 50 | 100 |
D | 160784 | 150 | 200 |
C | 70417 | 250 | 300 |
C | 160784 | 350 | 400 |
| | GSSE | GTRS |
D | 70417 | 50 | 100 |
C | 70417 | 50 | 100 |
D | 160784 | 150 | 200 |
C | 160784 | 150 | 200 |
<tbody>
</tbody>
The second table comes from these formulas:
GSSE | GTRS | ||
D | 70417 | =INDEX($A$2:$D$6;MATCH($B11;$B$2:$B$6;0);MATCH(C$10;$A$2:$D$2;0)) | =INDEX($A$2:$D$6;MATCH($B11;$B$2:$B$6;0);MATCH(D$10;$A$2:$D$2;0)) |
C | 70417 | =INDEX($A$2:$D$6;MATCH($B12;$B$2:$B$6;0);MATCH(C$10;$A$2:$D$2;0)) | =INDEX($A$2:$D$6;MATCH($B12;$B$2:$B$6;0);MATCH(D$10;$A$2:$D$2;0)) |
D | 160784 | =INDEX($A$2:$D$6;MATCH($B13;$B$2:$B$6;0);MATCH(C$10;$A$2:$D$2;0)) | =INDEX($A$2:$D$6;MATCH($B13;$B$2:$B$6;0);MATCH(D$10;$A$2:$D$2;0)) |
C | 160784 | =INDEX($A$2:$D$6;MATCH($B14;$B$2:$B$6;0);MATCH(C$10;$A$2:$D$2;0)) | =INDEX($A$2:$D$6;MATCH($B14;$B$2:$B$6;0);MATCH(D$10;$A$2:$D$2;0)) |
<colgroup><col span="2"><col span="2"></colgroup><tbody>
</tbody>
PROBLEM is: I get the same values for D and C in column A!!
How do I add an extra criteria so the result looks like the first table but only with formulas?
Extra: right now there is 2 times the letter D in column A. The number of times this value D appears in the column can change over time, the column is always sorted A-Z so all the values D will show under each other. Right now it's A3:A4 that contains the D, but if more D are added then the 4 will expand. Is it possible to include this in the answer please?
Same goes for C ofcourse ^^
Thank you!!
Much obliged,
Alex