Index match array returning some values correct and about 3 or 4 are incorrect

Copper Contributor

I have this formula that I use to return about 50 values. Of the 50, 3 is incorrect somehow for those 3 it select the next row which doesnt fall in the criteria but it does it anyway. If I search and get 8 values, 3 is incorrect. I am at a loss, why would it do that:

 

Example: This is in Row22 and it is correct:

=IFERROR(INDEX(REPAIR_TB,SMALL(IF(REPAIR_TB[RMR]=$B$10,ROW(REPAIR_TB[RMR])),ROWS(A$22:A22)),5),"")

 

Same formula is in Row 73 and it return a incorrect info 

=IFERROR(INDEX(REPAIR_TB,SMALL(IF(REPAIR_TB[RMR]=$B$10,ROW(REPAIR_TB[RMR])),ROWS(A$22:A73)),5),"")

 

 

Please help

1 Reply

@Tartis 

Can you please upload a workbook that demonstrates the formula, and indicate why some of the results are incorrect? And what result would you want to see for these errors.