Try this in E2:

=AND(A2=B2,B2=C2,C2=D2,A2<"")

and copy down as far as you need. This will return TRUE or FALSE, as
appropriate.

Hope this helps.

Pete

On Apr 22, 12:06*am, Whitney
wrote:
I have a spreadsheet with 4 columns, each with a list of names. The names are
mostly the same, from 4 different resources, but some are mispelled. I would
like the 5th column to say True/False or Y/N if any of the names in a row
do/do not match, assuming blank cells as a match.

Ex.
DB * * * * * * * * Cisco * * * * * *Attendance * *Outlook * * * * *Match? *
Amy Smart * *Amy Smart * *Amy Smart * *Amy Smart * * Y or True
Bob Smith * * Bib Smith * * * Bob Smith * * Bob Smith * * * N or False