testing a value

[drag-driver]

I have a value in cell A1 and i want to return the value true in C1 if A1 is equal to any value in the colum B. Columb B contains 150 cells of data.

 

[Mark W.]

{=OR(A1=B1:B150)}

Note: This is an array formula which must be entered using the Control+Shift+Enter key combination. The outermost braces, { }, are not entered by you -- they're supplied by Excel in recognition of a properly entered array formula.

Or...

=ISNUMBER(MATCH(A1,B:B,0))
This message was edited by Mark W. on 2002-03-05 08:57

 

[Steve Hartman]

=IF(ISNA(MATCH(A1,B:B,0)),"","True") in C1 will check all of column B in case the number of entries might change.

 

[Aladin Akyurek]

On 2002-03-05 08:34, drag-driver wrote:
I have a value in cell A1 and i want to return the value true in C1 if A1 is equal to any value in the colum B. Columb B contains 150 cells of data.

In C1 enter: =ISNUMBER(MATCH(A1,B:B,0))

If needed, B:B can be replaced by B1:B150.

 

[Mark W.]

On 2002-03-05 08:59, Aladin Akyurek wrote:

On 2002-03-05 08:34, drag-driver wrote:
I have a value in cell A1 and i want to return the value true in C1 if A1 is equal to any value in the colum B. Columb B contains 150 cells of data.

Been there... done that!

In C1 enter: =ISNUMBER(MATCH(A1,B:B,0))

If needed, B:B can be replaced by B1:B150.