Joe4
Ran into a problem
Q is my converted From range
R is my converted To range
S is the value I am looking up
D is where the formula resides
In cell D3 I have =IF(COUNTIFS(Q:Q,">=" & S3,R:R,"<=" & S3)>0,"Yes","No")
The converted value in S3 is 1012619321
The converted value in Q4 is 1012619321
The converted value in R4 is 1012619322
The formula should return "Yes" because the value in S3 is >= to Q4 value