I am asking this same question few different forums, here where I am posting at :
MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
I'd like to crawl a keyword from sheet 2 colomn A:B (consist of multiple text and sentences) into sheet 1 colomn B (noting from sheet 2 colomn A). Please tell me the formula.
Sheet 1 : https://prnt.sc/KO9_cq8rLBvF
Sheet 2 : https://prnt.sc/7gM6G4CsOxrm
This is for google excel sheet