IF or FILTER statement to decide if a Cell and its length Falls between ranges

Harun24HR Thanks for the response. It was close and you have actually come up with something similar to what i came up with. The only issue is it doesnt account for long defects that continue under multiple sleeves. This is accounting for the start of the defect which sleeve it would be under whereas i need to account for any sleeve that the defects that are "SLEEVED" fall under from the axial start including their length so thats why its so complicated. MFG-001 as it goes under multiple sleeves should be shown as additional defects under a few sleeves there. I originally made another column for defect axial start plus length to find the lookup for the sleeve end so that covers me for defects that are greater than 1 sleeve long when the sleeves are butted up end to end but it still doesnt account for if the defect is so long that it falls under 3+ sleeves. basically i need the formula to be nearly as simple as if the defect (from start to end ( so from start plus the length /1000 to get length in m)) if any part of that defect falls under a sleeve and has SLEEVED in the repair decision column i need to show all the sleeves that the defect falls under so that on the sleeve page each sleeve shows which defects the sleeves are covering. Its really quite complicated because it adds another element of length into the equation. not just starting point. i was thinking of making some big formula that checks which sleeve the axial start is under then 1/100th of the length plus axial start then 1/90th plus axial start and so on until ive covered the whole defect length but thats quite cumbersome and i was hoping someone would have a simpler answer. Thanks for the help and sorry that its so complicated!