Check multiple cells for a match

[RodneyW]

Users enter data into cell AM53. This code in cell AN53

=IF(AM53="","",IF(BB53=AM53,"Y","N"))

looks to see if AM53 matches BB53 and if so, it produces a "Y". Example, AM53 says Fort Lauderdale. If BB53 says Fort Lauderdale, it produces a "Y". However, if someone enters an alternative spelling into AM53, Ft Lauderdale or Ft. Lauderdale, both of which are acceptable answers, I want a "Y" to appear. With the current formula anything other than specifically Fort Lauderdale, will produce a "N".

How do I modify this =IF(AM53="","",IF(BB53=AM53,"Y","N")) to take into account BC53 and BD53 ?

Thanks in advance

 

[dreid1011]

Perhaps this:

=IF(AM53="","",IF(OR(BB53=AM53,BC53=AM53,BD53=AM53),"Y","N"))

 

[RodneyW]

Perhaps this:

=IF(AM53="","",IF(OR(BB53=AM53,BC53=AM53,BD53=AM53),"Y","N"))

YAHTZEE! Thank you

 

[dreid1011]

YAHTZEE! Thank you

You're welcome and happy to help.