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

TR-1395

TR-0076

TR-0042

TR-0015

TR-1443

TR-1276

TR-0088

TR-1439

TR-0026

TR-1456

TR-0019

TR-0009

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[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.