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

%3CLINGO-SUB%20id%3D%22lingo-sub-1066223%22%20slang%3D%22en-US%22%3EIndex%20match%20array%20returning%20some%20values%20correct%20and%20about%203%20or%204%20are%20incorrect%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1066223%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20this%20formula%20that%20I%20use%20to%20return%20about%2050%20values.%20Of%20the%2050%2C%203%20is%20incorrect%20somehow%20for%20those%203%20it%20select%20the%20next%20row%20which%20doesnt%20fall%20in%20the%20criteria%20but%20it%20does%20it%20anyway.%20If%20I%20search%20and%20get%208%20values%2C%203%20is%20incorrect.%20I%20am%20at%20a%20loss%2C%20why%20would%20it%20do%20that%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%20This%20is%20in%20Row22%20and%20it%20is%20correct%3A%3C%2FP%3E%3CP%3E%3DIFERROR(INDEX(REPAIR_TB%2CSMALL(IF(REPAIR_TB%5BRMR%5D%3D%24B%2410%2CROW(REPAIR_TB%5BRMR%5D))%2CROWS(A%2422%3AA22))%2C5)%2C%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESame%20formula%20is%20in%20Row%2073%20and%20it%20return%20a%20incorrect%20info%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIFERROR(INDEX(REPAIR_TB%2CSMALL(IF(REPAIR_TB%5BRMR%5D%3D%24B%2410%2CROW(REPAIR_TB%5BRMR%5D))%2CROWS(A%2422%3AA73))%2C5)%2C%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1066223%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1066257%22%20slang%3D%22en-US%22%3ERe%3A%20Index%20match%20array%20returning%20some%20values%20correct%20and%20about%203%20or%204%20are%20incorrect%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1066257%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F488460%22%20target%3D%22_blank%22%3E%40Tartis%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20please%20upload%20a%20workbook%20that%20demonstrates%20the%20formula%2C%20and%20indicate%20why%20some%20of%20the%20results%20are%20incorrect%3F%20And%20what%20result%20would%20you%20want%20to%20see%20for%20these%20errors.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted

@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.