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