asdf99
New member
- Joined
- Jun 30, 2022
- Messages
- 9
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Professional 2021
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
View attachment Vlookup crawls.xlsx
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
View attachment Vlookup crawls.xlsx