Search for multiple strings in multiple colums

[ranmyaku]

I've tried to figure out how to do this myself with multiple searches but have been unsuccessful.

I have a large list of strings that I want to check against numerous columns containing strings.

The output that I want is either "Y" or "N" if any of the strings matches.

I have attached an excel file with an example that is smaller but similar to what I want to do.

Thanks.Example 1.xlsx

[Haseeb Avarakkan]

Try this in B2

=IF(SUMPRODUCT(COUNTIF(D2:Z2,A$2:A$4)),"Y","N")

Copy down...

[ranmyaku]

Thanks so much!

[ranmyaku]

One other thing has come up which it doesn't look like the above will catch.

If the string to match is "311", how can I get it to recognize any string that starts with 311.xx.

So that 311.1 or 311.2 will show up as a yes, if the string to match column just has 311?

[Haseeb Avarakkan]

Try COUNTIF with wildcard;

=IF(SUMPRODUCT(COUNTIF(D2:Z2,A$2:A$4&"*")),"Y","N")

Assuming your data always be string NOT real numbers.