Jun 30 2022 04:50 AM
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
Jun 30 2022 01:13 PM - edited Jun 30 2022 01:15 PM
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"?
Jun 30 2022 07:24 PM
Jun 30 2022 11:04 PM
Jun 30 2022 11:44 PM
@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
Jul 01 2022 12:06 AM
Jul 01 2022 12:16 AM
@asdf_99 On MrExcel you mentioned that you work with Excel 2021. There's no such thing as "Google Excel".
Jul 01 2022 12:29 AM
Jul 01 2022 12:33 AM
Jul 01 2022 12:43 AM
@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
Jul 01 2022 12:49 AM
Jul 01 2022 01:35 AM - edited Jul 01 2022 01:37 AM
@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!
Jul 01 2022 02:02 AM
Jul 01 2022 02:13 AM
@asdf_99 Sorry to be blunt. You are wasting my time. Are you using Microsoft Excel? If so, which version and on which platform?
If you are using Google Sheets, try the link below:
https://support.google.com/docs/topic/9054603?hl=en&ref_topic=1382883
Jul 01 2022 02:26 AM
Jul 01 2022 03:04 AM
@asdf_99 So you do have Excel 2021. Then the formula should work. Have no more suggestions for you.
Jul 01 2022 03:09 AM
Jul 01 2022 03:18 AM
@asdf_99 For the last time! What is a "google excel sheet"?
Jul 01 2022 03:33 AM
Jul 02 2022 06:23 AM