search string plug Y of found

[makinmomb]

Devmin - rem+stor+cwr
gold aged - p/c
beltexco - p/c + rem+ stor
mpunga - rem + stor + cwr
kalonji kasaka - stor
arazam - stor + cwr
beltexco - p/c
kalonji - rem+stor+cwr
longlihua - stor
kaska kalonjee - rem+stor+cwr
lunga mabinga - rem+stor+cwr
beltexco - rem+ stor+cwr

 

[makinmomb]

I have this on c1 and need formula on d1 to plug y or n , to look for the word stor anywhere appear

 

[makinmomb]

Then i have this on sheet2

[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]TR-1395[/TD]
[/TR]
[TR]
[TD]TR-0076[/TD]
[/TR]
[TR]
[TD]TR-0042[/TD]
[/TR]
[TR]
[TD]TR-0015[/TD]
[/TR]
[TR]
[TD]TR-1443[/TD]
[/TR]
[TR]
[TD]TR-1276[/TD]
[/TR]
[TR]
[TD]TR-0088[/TD]
[/TR]
[TR]
[TD]TR-1439[/TD]
[/TR]
[TR]
[TD]TR-0026[/TD]
[/TR]
[TR]
[TD]TR-1456[/TD]
[/TR]
[TR]
[TD]TR-0019[/TD]
[/TR]
[TR]
[TD]TR-0009[/TD]
[/TR]
</tbody>[/TABLE]

 

[makinmomb]

The above on a1 downwards , Need formula on b1 , lookup the above on sheet1 , on a1 , and see if d1 is Y , then pull value e

 

[makinmomb]

Search for the word
STOR
plug Y if found
otherwise
N

 

[makinmomb]

If formula quotes Y , VLOOKUP values otherwise not

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules. Be sure to follow & read the link at the end of the rule too!

Cross posted at: https://www.excelforum.com/excel-formulas-and-functions/1247947-search-text-if-found-plug-y.html

If you do cross-post in the future and also provide a link, then there shouldn’t be a problem.