Or function?

Posted by Paul B on September 05, 2001 8:13 AM

I need a formula in B2 to display 1 if the number in A2 matches the numbers in A1 or B1 or C1 or D1 otherwise it should show "". Thanks

Posted by Mark W. on September 05, 2001 8:19 AM

{=IF(OR(A2=A1:D1),1,"")}

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

Posted by Aladin Akyurek on September 05, 2001 8:21 AM

=IF(ISNUMBER(MATCH(A2,A1:D1,0)),1,"")

will also work.

Aladin