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 very sorry if I had wasted my time but I very much appreciate of your help. I have tried that link but were not able to find the formula I was looking for nor any kinds of forum..
here's my excel version https://prnt.sc/LPSUZ25fCeHD
here's my excel version https://prnt.sc/LPSUZ25fCeHD
asdf_99 So you do have Excel 2021. Then the formula should work. Have no more suggestions for you.
solved here https://www.mrexcel.com/board/threads/vlook-up-crawls.1209378/page-2#post-5908551
- Hi @Riny,
Sorry for the confusion, what I meant was 'Google sheet'. But I would love to try and do it in Ms excel offline for now since it would still be ok for me.
Thank You asdf_99 For the last time! What is a "google excel sheet"?
- Hi @riny,
I am very sorry to have wasted your time and truly appreciate your great endeavor in helping. But as I mentioned earlier, it worked, but then got broken right away so I could not use it properly.
Here what happened :
1. I opened your file, result was good
2. I clicked on the field (sheet 1 A2), (because I tried to copy - paste the formula to my google excel sheet.
3. then I let go of my cursor from the field
4. then the result became error '#NAME?'
https://prnt.sc/ST-V2oDcQKZ7