Help with ranges

[Flamikey]

I would like to do the following formula....

Cell A1 = 40000
Cell B1 = Cell A1+1
Cell C1 = Cell B1 +1
Etc

I have several ranges in another worksheet. The ranges are a
follows:

Col A Col B
40000 40100
42100 42100
42200 42200
42300 42300
42400 42400
41000 41000
50050 50900
51200 51400
51100 51150
52000 52100

I would like my formula to state IF cell A1 (40000) is in any of thes
ranges then True otherwise false. Any easy way to do this?

I wish excel had a function "IN LIST" like SQL. Does such a functio
exist?

Thank

 

[Frank Kabel]

Hi
not sure about your first question?. You already have the formula?

For your second question (within the range), try the following formula
=IF(SUMPRODUCT(--('other sheet'!A1:A1000<=A1),--('other
sheet'!B1:B1000>=A1)),TRUE,FALSE)