Range Across Range? (With Values instead of dates)

[Ben H]

Hi

I am looking for a solution to find if a range overlaps another range.

Range 1Range 2
ABCDOverlap?
75000230000110260130000
22500400004351048090
37500600005182058440
800001100008975096880
600009500072090180000

I have looked at a few attempted solutions and they don't seem to work ...

=IF(OR(AND(D5>=F5,D5<=G5),AND(E5>=F5,E5<=G5)),"Overlap","Do not overlap")

=SUMPRODUCT((C1=$C$5:$C$261)* ((D1<=$G$5:$G$261)* (E1>=$F$5:$F$261)+ (F1<=$E$5:$E$261)* (G1>=$D$5:$D$261)))>0

=SUM((D5<F5:G5)*(E5>=F5:G5),(E5>F5:G5)*(D5<=F5:G5),(D5>=A$2:A$4)*(E5<=F5:G5))>0

Does anyone know a solution?

I would like the text "Overlap" or "Do not overlap"

Thanks

Mod Edit: Question moved to appropriate section

 

[Khalid NGO]

Hi Ben, Good day.

Please post a sample file.

Regards,