NEW PROBLEM WITH RANGE MATCHING

[Excel_Legend]

Can anyone tell me why when my range in cells contains 10-number, 11- number and 12-number I get the results I need, but once its 13-number and higher it doesnt return anything
=IFERROR(INDEX('EQUIPMENT LOG'!$A$6:$A$10,MATCH(1,IF((--'EQUIPMENT LOG'!$I$6:$I$10=A3),1,(IF(A3>=--LEFT('EQUIPMENT LOG'!$I$6:$I$10,--FIND("-",'EQUIPMENT LOG'!$I$6:$I$10)-1),IF(A3<=--RIGHT('EQUIPMENT LOG'!$I$6:$I$10,LEN('EQUIPMENT LOG'!$I$6:$I$10)-FIND("-",'EQUIPMENT LOG'!$I$6:$I$10)),1))))*('EQUIPMENT LOG'!$O$6:$O$10<>"IN"),0)),"")

for what I can tell when the left number is 10/11/12 (--'EQUIPMENT LOG'!$I$6:$I$10=A3) returns a false,false,false,false,false and so everything falls in place but when its 13+
the values for (--'EQUIPMENT LOG'!$I$6:$I$10=A3) false,false,#value,false false, for context values in I7-I10 are 1, 12-15(or 13-15),4-8,3, everything returns correct except for 13+,

 

[awoohaw]

can you provide a mini worksheet using the xl2bb add in?
It looks like all your reference data is on 1 sheet, and your formula is on another.
for the purposes here, just use the formula in question on the one sheet.

It makes the formula a little easier to read and easier for the forum to work on a solution:

=IFERROR(INDEX($A$6:$A$10,MATCH(1,IF((--$I$6:$I$10=A3),1,(IF(A3>=--LEFT($I$6:$I$10,--FIND("-",$I$6:$I$10)-1),IF(A3<=--RIGHT($I$6:$I$10,LEN($I$6:$I$10)-FIND("-",$I$6:$I$10)),1))))*($O$6:$O$10<>"IN"),0)),"")