Copy Cell A in Cell C if a word is found in cell B

[maudwork]

Hi,

I would like to find a formula than can do the following:

Post in the current cell where I'm writing the formula (cell V5) the text contained in cell J5, if the text "Apple" is found in L5.

I almost got it with this formula : =IF(L5="Apple",J5,"") but it didn't work because, event though I did have "Apple" in L5, there were also other words there so it didn't find that it matched the exact content. I need the J5 cell to be copied even if there are other words in L5, in addition to the one I was looking for. Is that possible?

Thank you for your help!

 

[PatOBrien198]

=IF(FIND("Apple",L5)>0,J5,"")

 

[maudwork]

=IF(FIND("Apple",L5)>0,J5,"")

It works, thanks PatOBrien198! New question: Now there's a message "#VALUE!" when the value isn't found in the cell, is it possible to have nothing in the cell instead of that error message?