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...
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
asdf_99 Used the file you uploaded to MOTH, the formula you got on MrExcel and pasted it into the file. It worked, provided you really are using Ms365, Excel 2021 or the on-line version.
See attached.
And, if this resolves your issue, you should perhaps close the threads on all other message boards
- Thank you, but I have tried this as I try to copy paste it then it became error (https://prnt.sc/h9UjnfWxo0SC), see this is what had 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?'asdf_99 Oh my! what is "Google Excel"? If you are referring to GoogleSheets the functions probably doesn't work there. you need to ask your question in a Forum that deals with GoogleSheets, not Excel!