Good Afternoon

Can anyone help with following? I have searched for an answer but it is beyond my knowledge unfortunately.

I have this data in one column which is the winning distances and the number of times they have won at that distance 1(1000) 1(1200) 1(1300) 1(1450) 1(1550)

In a second column I have the distance of todays race 1000

In a third column I would like have a yes or no for the following. The horses winning distance range from the above data is 1000-1550 and it is contesting a 1000m race so that would be a yes as it fits within the the horses winning distance range. Of course if todays race was 1800m it would be a no.

I do have a column that JFC helped me with which could be used if it is easier which just has the winning distance range.



Thanks
Twodogs