Forum Discussion
asdf_99
Jun 30, 2022Copper Contributor
Vlook Up Crawls
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
- Riny_van_EekelenPlatinum Contributor
Found your post here as well.
https://www.myonlinetraininghub.com/excel-forum/excel/vlook-up-crawls#p25594
By the way, what is "crawl a keyword"?
- asdf_99Copper ContributorI am posting at few different forums here :
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
what I meant by crawl is retrieving, so in my case, it crawls colomn A at sheet 2 then retrieve it to colomn B at sheet 1.- Riny_van_EekelenPlatinum Contributor
asdf_99 The link to MrExcel is incorrect. Nevertheless, I found you there and it seems you have an answer there already.
https://www.mrexcel.com/board/threads/vlook-up-crawls.1209378/page-2#posts
- asdf_99Copper ContributorOK I understood now what you meant... because I thought one forum may have different people in the community
Because i usually post in excelforum.com and they can reply fast and very well..., but right now they are down... so I am really in need of a such a great help and fast responds..
thank you