I have Worksheet A containing a list of data:
Red, Yellow, Orange, Purple which is defined in NAME MANAGER as COLOR

Worksheet B on CELL A1, is user input data

A2 has the following formula
=OR(A1=COLOR)

User input : Red = FALSE
Yellow = FALSE
Orange = True
Purple = FALSE

The OR formula should produce TRUE value on the cell for all input that is
true. However, it is not the case. Where is the formula wrong?

Try this instead:

=ISNUMBER(MATCH(A1,COLOR,0))

Hope this helps.

Pete

On Feb 24, 12:19*am, apache007
wrote:
I have Worksheet A containing a list of data:
Red, Yellow, Orange, Purple which is defined in NAME MANAGER as COLOR

Worksheet B on CELL A1, is user input data

A2 has the following formula
=OR(A1=COLOR)

User input : *Red * *= *FALSE
* * * * * * * * * Yellow *= FALSE
* * * * * * * * * *Orange = True
* * * * * * * * * Purple * = FALSE

The OR formula should produce TRUE value on the cell for all input that is
true. However, it is not the case. Where is the formula wrong?

Your formula should be working as expected if it will be treated as an
'Array-Formula'.
{=OR(A1=COLOR)}
Which means:
It is to be confirmed with CTRL+SHIFT+ENTER rather than with simply ENTER.
The curly brackets {} are not to be typed manually, those are entered by the
€œExcel€�, when the formula is entered as an Array formula.
Micky


"apache007" wrote:

I have Worksheet A containing a list of data:
Red, Yellow, Orange, Purple which is defined in NAME MANAGER as COLOR

Worksheet B on CELL A1, is user input data

A2 has the following formula
=OR(A1=COLOR)

User input : Red = FALSE
Yellow = FALSE
Orange = True
Purple = FALSE

The OR formula should produce TRUE value on the cell for all input that is
true. However, it is not the case. Where is the formula wrong?