Text String Analysis 2

[mimih23]

Please see the original data source below:
[table="width: 500, class: grid, align: right"]
[tr]
[td]Indicator[/td]
[td]Sequence Data[/td]
[/tr]
[tr]
[td]Mom[/td]
[td]5,6,7[/td]
[/tr]
[tr]
[td]Dad[/td]
[td]2[/td]
[/tr]
[tr]
[td]Sister[/td]
[td]2,7[/td]
[/tr]
[tr]
[td]Brother[/td]
[td]6,7[/td]
[/tr]
[tr]
[td]Brother[/td]
[td][/td]
[/tr]
[tr]
[td]Mom[/td]
[td][/td]
[/tr]
[tr]
[td]Aunt[/td]
[td]2[/td]
[/tr]
[tr]
[td]Aunt[/td]
[td][/td]
[/tr]
[tr]
[td]Uncle[/td]
[td]5[/td]
[/tr]
[/table]

On Worksheet 2, I would like the formula to yield the following in the Sequence Data column. The Indicator column will simply be the source data without duplicates:
[table="width: 500, class: grid, align: right"]
[tr]
[td]Indicator[/td]
[td]Sequence Data? Yes or No?[/td]
[/tr]
[tr]
[td]Mom[/td]
[td]Yes[/td]
[/tr]
[tr]
[td]Dad[/td]
[td]No[/td]
[/tr]
[tr]
[td]Sister[/td]
[td]Yes[/td]
[/tr]
[tr]
[td]Brother[/td]
[td]Yes[/td]
[/tr]
[tr]
[td]Aunt[/td]
[td]No[/td]
[/tr]
[tr]
[td]Uncle[/td]
[td]Yes[/td]
[/tr]
[/table]

Sequence data equals any variation of the numbers 5,6,and/or 7 in the Sequence Data Column per Indicator. So if a 2 and a 7 exist in the sequence data column, because 7 is present, the formula should yield a "yes". Let me know if this makes sense. Thank you in advance for your help.

 

[Aladin Akyurek]

Is the indicator column in Sheet2 already available or must it obtain from Sheet1 by means of a formula?

 

[mimih23]

The indicator column is already available in Sheet2 per a copy/paste and remove duplicate process. So for this purpose, yes, the indicator column in sheet 2 is already available.

 

[Aladin Akyurek]

The indicator column is already available in Sheet2 per a copy/paste and remove duplicate process. So for this purpose, yes, the indicator column in sheet 2 is already available.

In B2 of Sheet2 control+shift+enter, not just enter, and copy down:

=IF(SUM(IF(ISNUMBER(SEARCH({5,6,7},IF(Sheet1!$A$2:$A$10=$A2,Sheet1!$B$2:$B$10,"#"))),1)),"Yes","No")

 

[mimih23]

Is "#" the default for the population of any digit found in the original source. Interesting.
Thanks this works!!! I need to grow a larger brain.

 

[Aladin Akyurek]

Is "#" the default for the population of any digit found in the original source. Interesting.

That means: Return a # when A-range of Sheet1 is not equal to the test indicator as part of the IF evaluation.

Thanks this works!!! I need to grow a larger brain.

You are welcome.