View Single Post
  #1   Report Post  
Posted to microsoft.public.windowsxp.general,microsoft.public.excel.programming
Garima[_2_] Garima[_2_] is offline
external usenet poster
 
Posts: 1
Default 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