calc find sentence[in column B] containing specific word[A1] and copy sentence to [c1]

[andradada]

      A | B |C |D |E ...
    1 word| xxx | sentence containing word 
    2 word2 |xxx | xxx
    3 word3|xxx | xxx
    4 word4 | xxx| xxx
    5 word5 | sentence containing word  | xxx
    ...

How can I find a word, and then search that word on another column, and then copy to the third column?

[erAck]

In C1, depending on what you have enabled under Tools → Options → Calc → Calculate:

• If wildcards: =VLOOKUP("*"&A1&"*";B1:B999;1;0)
• If regular expressions: =VLOOKUP(".*"&A1&".*";B1:B999;1;0)
• If neither: not possible

Of course use your actual data range with sentences instead of B1:B999.