IF/THEN or SEARCH/REPLACE Formula Assistance Needed

[KellyPoling]

I need help with a search if/then formula. 

If Column A contains a keyword from Column E, the Value from Column F is copied to a blank Column B.

[#2]

@KellyPoling 

That could be

=IFNA(INDEX(F:F,MATCH(1,INDEX(ISNUMBER(SEARCH(E:E,A2))*(E:E<>""),0),0)),"no such")

in B2 and drag it down

[#3]

@Sergei Baklan - Thank you so much! That worked

[#4]

@KellyPoling , you are welcome