find if number is a match

Trying to find if the number entered in the input box "num_cmp" is => Cells(i, 2) AND <= Cells(i, 3) ? So basically if "num_cmp" is with the range of the numbers in Cells(i, 2)) or Cells(i, 3)) or an extact match of Cells(i, 2)) or Cells(i, 3)) . should be easy but I'm stuck?


num_cmp = InputBox("Please enter number:")

If num_cmp = "" Then

Exit Sub
End If


    i = 1
    num = 0

 Do While Not IsEmpty(Cells(i, 2))
       
        div = Cells(i, 2)
        
        lne = Cells(i, 3)