Dave,
Use the FIND function. Put it in the column next to your list and
reference M17. Filter on that 2nd column

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"David Kinsley" wrote:

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