Vlook Up Crawls

[asdf_99]

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:

sheet 2:

 

[Peter_SSs]

Welcome to the MrExcel board!

Try this

asdf_99.xlsm
	A	B
1
2	SD	adam kjdskal adam ask
3	LD	asd kilo
4	DN	ask adam
Sheet2

asdf_99.xlsm
	A	B
1
2	adam	SD, DN
3	kilo	LD
4	kolo
5	ask	SD, DN
Sheet1

Cell Formulas
Range	Formula
B2:B5	B2	=TEXTJOIN(", ",1,FILTER(Sheet2!A$2:A$4,ISNUMBER(FIND(" "&A2&" "," "&Sheet2!B$2:B$4&" ")),""))

 

[asdf_99]

sorry, I've tried but did not work. Can you resend for google excel sheet please ?
thanks

Welcome to the MrExcel board!

Try this

asdf_99.xlsm
	A	B
1
2	adam	SD, DN
3	kilo	LD
4	kolo
5	ask	SD, DN
Sheet1

Cell Formulas
Range	Formula
B2:B5	B2	=TEXTJOIN(", ",1,FILTER(Sheet2!A$2:A$4,ISNUMBER(FIND(" "&A2&" "," "&Sheet2!B$2:B$4&" ")),""))

 

[Peter_SSs]

Can you resend for google excel sheet please ?

Sorry, no. You have asked the question in an Excel Questions forum.
I have now moved your question to the appropriate forum.

 

[asdf_99]

Sorry, no. You have asked the question in an Excel Questions forum.
I have now moved your question to the appropriate forum.

I even have tried this on ms excel offline does not works

 

[asdf_99]

when do I can receive an answer ?

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: VlookUp Crawls - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[asdf_99]

I thought I have just posted once in excel section, then someone moved it/copied it to google section...

 

[Fluff]

Yes but you have also posted it on OzGrid without supplying a link.

 

[asdf_99]

OK I understood now what you meant... because I thought one forum may have different people in the community