Hi Experts,
I am looking for a formula to return row number to automate Index formula.
Cell E1 gives me result "6". However in formula I wish +2 should be automated.
Formula should first look for value in column D in column A, then it should look for subsequent "Total" in column B and return appropriate value against "Total".
<tbody>
</tbody>
I am looking for a formula to return row number to automate Index formula.
Cell E1 gives me result "6". However in formula I wish +2 should be automated.
Formula should first look for value in column D in column A, then it should look for subsequent "Total" in column B and return appropriate value against "Total".
A | B | C | D | E | |
1 | ABCD | Pen | 3 | ||
2 | Pencil | 3 | |||
3 | Total | 6 | |||
4 | XYZ | Pen | 4 | ABCD | =INDEX(C:C,MATCH(D4,A:A,0)+2)=6 |
5 | Pencil | 3 | XYZ | =INDEX(C:C,MATCH(D5,A:A,0)+3)=9 | |
6 | Eraser | 2 | |||
Total | 9 |
<tbody>
</tbody>