Search a value in particular range
I have data in column A : 100, 102, 105, 110
I have data in cell B1 : 10
I want to check whether value 103 comes in range 100, 102, 105, 110
Here in the given case it has come, as value 105 appears which includes 103.
I need a formula to check when value 103 arrives or arrived in that range.
In given case it arrived at 105
Please help me
Thank
|