VlookUp Crawls

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

mrexcel.com/board/threads/vlook-up-crawls.1209378/

https://www.excelguru.ca/forums/show...Crawls&p=47765
https://www.mrexcel.com/board/thread...2#post-5908402
https://techcommunity.microsoft.com/...ls/m-p/3562564
https://www.myonlinetraininghub.com/...-crawls#p25593

Hi

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.

Thank You

Sheet 1 : https://prnt.sc/KO9_cq8rLBvF

Sheet 2 : https://prnt.sc/7gM6G4CsOxrm

This is for google excel sheet

I have read and will follow all the rules and guideline...



Please let me know if I have missed something, here's where I have posted my questions :



https://www.excelguru.ca/forums/show...Crawls&p=47765

https://www.mrexcel.com/board/thread...2#post-5908402

https://techcommunity.microsoft.com/...ls/m-p/3562564

https://www.myonlinetraininghub.com/...-crawls#p25593