Problems creating my dynamic list from a range not on the top row of the sheet

[MurphDog]

My goal is to get to a point where I have created my own debt snowball / avalanche calculator that I can place in my own workbook. Sure I could use an excellent debt reduction calculator I found on the internet, but to send data to it and pull data from it is a pain. It would be better if I could just do it all in the same document.

Step 1 of my goal is that I'm working on is pulling the only debts with a balance from one range and creating a new table. The range has 10 rows, plus the header.

So during my googling, I found a short video tutorial with this working formula....

=IFERROR(INDEX($A$2:$A$26,SMALL(IF($B$2:$B$26=$K$1,ROW($A$2:$A$26)),ROW(1:1))-1,1),"")

I created an identical formula in the same sample document, with my test data and it works, where A2 is the start of the range

=IFERROR(INDEX(Sheet1!$A$2:$A$11,SMALL(IF(Sheet1!$F$2:$F$11=$H$13,ROW(Sheet1!$A$2:$A$11)),ROW(Sheet1!1:1))-1,1),"")

But as soon as I move the range to where it is actually located (F6), the results are not accurate

=IFERROR(INDEX(Sheet1!$F$6:$F$15,SMALL(IF(Sheet1!$L$6:$L$15=$H$13,ROW(Sheet1!$F$6:$F$15)),ROW(Sheet1!1:1))-1,1),"")

I'm pretty sure it has to do with the ROW portion of the formula but I've never used that before and don't really understand the need for it.

Please advise.

 

[AlphaFrog]

Change the -1 to -5

Think of it as an offset from your starting row. So if you start at row 6, then use -5 to return the first match

=IFERROR(INDEX(Sheet1!$F$6:$F$15,SMALL(IF(Sheet1!$L$6:$L$15=$H$13,ROW(Sheet1!$F$6:$F$15)),ROW(Sheet1!1:1))-5,1),"")

 

[MurphDog]

Awesome! Thanks!