Did you copy down to A10000 as Per suggested?


Gord Dibben MS Excel MVP

On Thu, 1 Apr 2010 12:39:21 -0700 (PDT), Pierre wrote:

Per, can it be adjusted to find a "Yes", or "No", if the value is
found (or not found) within all the cells in the entire column, not
just the range in A1? Lets say A2:A10000?
I tried replacing it with that and it didn't behave.

Thanks for your thoughts on this.

Pierre
On Apr 1, 1:56*pm, Per Jessen wrote:
Hi

This formula will return Yes if the number in B1 is in the range given
in A1.

=IF($B$1=LEFT(A1,FIND("-",A1)-1)*1,IF($B
$1<=MID(A1,FIND("-",A1)+1,999)*1,"Yes","No"))

The formula can be copied down as required.

Hopes this helps.
...
Per

On 1 Apr., 20:16, Pierre wrote:



In one column (b), have the figure of 470
In another column (a), a cell contains values containing a number, a
dash and another number: "425 - 490"
I need to check to determine if the number 470 is found within a range
defined by a cells contents. *In this case, yes, it's equal to or
between them.

(The dash may or may not have spaces around it. *..could be 425-490,
or 425 - 490.)
The column (b) item can be the 425, or the 490 and any number in
between.

Need to do a vlookup to find if the 470 is present in any of the
assorted ranges contained in column (a).

Thanks for your interest.
Pierre- Hide quoted text -

- Show quoted text -