Looking for a formula that can extract from columns B, C and D every time the value 3 appears in column B & 4 appears in column C.
The previous formula used was: {=IFERROR(INDEX(B$1:B$21,SMALL(IF($B$1:$B$21=$N$3,ROW($B$1:$B$21)),ROW(1:1))),"")}
Which only dealt with one criteria, and in this instance would have only returned every 3 digit string that had the value of 3 in the C column, however I am looking implement a second criteria in to the formula like the example below.
<tbody>
</tbody>
The previous formula used was: {=IFERROR(INDEX(B$1:B$21,SMALL(IF($B$1:$B$21=$N$3,ROW($B$1:$B$21)),ROW(1:1))),"")}
Which only dealt with one criteria, and in this instance would have only returned every 3 digit string that had the value of 3 in the C column, however I am looking implement a second criteria in to the formula like the example below.
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P |
| 3 | 1 | 2 | 4 | 3 | 4 | _ | |||||||||
| 4 | 3 | 4 | 7 | ||||||||||||
| 5 | 6 | 5 | 7 | 1 | 3 | 4 | 7 | ||||||||
| 6 | 2 | 7 | 3 | 2 | 3 | 4 | 0 | ||||||||
| 7 | 1 | 1 | 8 | 3 | 3 | 4 | 1 | ||||||||
| 8 | 0 | 0 | 2 | 4 | |||||||||||
| 9 | 7 | 0 | 3 | 5 | |||||||||||
| 10 | 5 | 5 | 5 | 6 | |||||||||||
| 11 | 2 | 5 | 9 | ||||||||||||
| 12 | 4 | 3 | 0 | ||||||||||||
| 13 | 7 | 7 | 2 | ||||||||||||
| 14 | 4 | 2 | 4 | ||||||||||||
| 15 | 2 | 2 | 2 | ||||||||||||
| 16 | 1 | 0 | 3 | ||||||||||||
| 17 | 7 | 1 | 3 | ||||||||||||
| 18 | 3 | 4 | 0 | ||||||||||||
| 19 | 7 | 2 | 4 | ||||||||||||
| 20 | 7 | 8 | 3 | ||||||||||||
| 21 | 3 | 4 | 1 |
<tbody>
</tbody>
Last edited:
