Return to Revisions

The link in your question is good, but it needs to be adjusted as follows.

=IFERROR(INDIRECT("B"&SMALL(IF(X25=$D$17:$D$22;ROW($D$17:$D$22);"");ROW($D$17:$D$22)-16));"")

Enter as an array formula {} by pressing Ctrl+Shift+Enter. The result is 4, 5, and 6 as you requested.

Adjustments:

• INDIRECT("B"& — In your case, you want the value from column B, not the index.
• X25= instead of "a"= because you want the value from that row.
• ROW($D$17:$D$22)-16 instead of ROW()-2 because the row number is from the D column, not from the location where you're putting the formula.

EDIT:

The OR function itself will not work in an array formula, so use the + operator instead.

=IFERROR(INDIRECT("B"&SMALL(IF((X25=$D$17:$D$22)+(X25=$E$17:$E$22);ROW($D$17:$D$22);"");ROW($D$17:$D$22)-16));"")

Result: 2, 3, 6