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

Hi
see your post in Excel.worksheet.fucntions
P.S.: please don't multipost

--
Regards
Frank Kabel
Frankfurt, Germany


Garima wrote:
I have data in column A : 100, 102, 105, 110

I have data in cell B1 : 103

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.

Thanks