is data in two character fields the same?

T

Ted @ PMI

I am trying to compare the contents of two character fields (names) to see if
they are the same. How can I do that?

Thanks,
 
C

Chip Pearson

=IF(A1=B1,"Match","No Match")

This is case insensitive. If you need a case sensitive match, use

=IF(EXACT(A1,B1),"Match","No Match")

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Top