Thread: is data in two character fields the same?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default is data in two character fields the same?
=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)


On Sat, 31 Jan 2009 14:34:05 -0800, Ted @ PMI
wrote:

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,
Reply With QuoteReply With Quote