Check If Cell Contains Text in LibreOffice Calc

This video goes over a few functions that can help with checking or finding specific text in a cell.
Using VLOOKUP video tutorial:
• How to use VLOOKUP in ...
For further info, here are official help pages:
Using the Find Function
help.libreoffice.org/latest/e...
Using the Search Function
help.libreoffice.org/latest/e...
Using the Match Function
help.libreoffice.org/latest/e...
Using the VLOOKUP Function
help.libreoffice.org/latest/e...