Per: You're a genius!

I knight you "Sir Per".
Thank you.
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 -