Forum Discussion
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 S...
I 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.
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.
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
- Yes, but the function was not working at all as it gave me not a valid function notification. Please send me in google excel sheet link so we all can know how to crawl it. Thank you
asdf_99 On MrExcel you mentioned that you work with Excel 2021. There's no such thing as "Google Excel".
- I have tried with a semicolon (;) but it did not worked also https://prnt.sc/CWMjj_0YPhJM