lookup simular values, return multiple variants

[nkaretnikov]

Hello!
I found a way with using INDEX and SMALL formulas to return multiple occurencies of the string in many rows. The formula is simple and a power tool, here is an example

=INDEX($B$2:$B$16;SMALL(IF($D$2=A2:A16;ROW(B2:B16)-1;"");ROW()-5))

The only thing that bugs me it this last ROW()-5. Each time I move this array formula I should not forget to change manually number of rows to subtract from current row.
Is there a way to get up-top row number in array formulas?
Thank you!

 

[Aladin Akyurek]

Where do you have this formula's first instance exactly?