LinkBack URL
About LinkBacks
Hi
I'd like to crawl keywords from sheet 2 (B2) which has many keywords under one field to sheet 1 colomn B2->B6 (just one keyword each) .
Please let me know the formula,
I would prefer done on google excel sheet though
thank you
Hi
I'd like to crawl keywords from sheet 2 (B2) which has many keywords under one field to sheet 1 colomn B2->B6 (just one keyword each) .
Please let me know the formula,
I would prefer done on google excel sheet though
thank you
Last edited by Asdf99; 06-29-2022 at 08:21 AM.
Please go back to your first thread here and mark it as solved, as I requested. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
solved and done giving some **
Your thread titles will need to be a bit more descriptive going forward, please.
Try this:
=IF(ISNA(LOOKUP(99999,SEARCH(A2,Sheet2!$B$2:$B$10),Sheet2!$B$2:$B$10)),"","Y")
thank you but sorry did not worked, so I wonder why B2:B10 ?
Last edited by Asdf99; 06-29-2022 at 09:46 AM.
Attach a workbook showing the problem. It worked for me.
I've just noticed that you have now decided that you want to use Google Sheets - I am moving this thread to the correct forum section.
Last edited by AliGW; 06-29-2022 at 09:56 AM.
can you please explan why B2:B10 ?
Last edited by Asdf99; 06-29-2022 at 10:03 AM.
sorry it does not works, may be caused im using this for google excel sheet. Please help me
It works in the attachment - I have shown you this. The range is in case further rows are added - make it just B2 if you want.
I cannot help you with GoogleSheets, sorry.
"It does not work" is of no help to us whatsoever: in what way is it not working?
sorry, my bad... it's working, so thank you so much !
Glad to have helped.
If you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks