I'm trying to use excel as a compliance tool. I have one cell, where the
name is manually typed in cell M17. For this example, let's say that the
name used is Ford. I then would like to compare "Ford" to several other
values. The other values I have are Ford Motor Company, Ford Credit Corp,
etc, etc. The list can be quite long. Is there a way to check if the if the
value in M17 matches any of the values in the list? Also is it possible that
it will flag it if it only has part of the word. For example, if the name is
Ford and checking against how can I get that to flag it eventhough it only
contains part of the values that are being checked.

The way I orginially tried to accomplish this was to write a nested if, such
as if(m17=s17, "CHECK",if(m17=s18,"CHECK","")). This obviously doesn't work
very well with long lists and doesn't solve my problem of flagging me if it
only contains part of the value being checked.

Any help would be immensely appreciated.

Thanks