Dear Bob,

You may want to try this array formula (Ctrl+Shift+Enter)

=OR(EXACT(A11,$B$11:$B$13))

Regards

Ashish Mathur


"bob" wrote:

> I have two columns of names. I want to find the names that match in each
> column and display a message, "MATCH," in a third column.
>
> I have tried this formula but it is not working:
>
> IF(A2=B2:B1000,"MATCH",0)
> Ctrl+Shift+Enter for array
>
> Can anyone help?
>
> Thanks,
> Bob