VlookUp Crawls

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,147
Reaction score
1
Points
38
Excel Version(s)
365

asdf99

New member
Joined
Jun 30, 2022
Messages
9
Reaction score
0
Points
0
Excel Version(s)
Professional 2021
[FONT=&quot]OK I understood now what you meant... because I thought one forum may have different people in the community[/FONT]
 

asdf99

New member
Joined
Jun 30, 2022
Messages
9
Reaction score
0
Points
0
Excel Version(s)
Professional 2021
[FONT=&quot]Because i usually post in excelforum.com and they can reply fast and very well..., but right now they are down... so I am really in need of a such a great help[/FONT]
 

asdf99

New member
Joined
Jun 30, 2022
Messages
9
Reaction score
0
Points
0
Excel Version(s)
Professional 2021
Hi

Ok I will when I have time to read them..
I noticed you are here and very happy to see you
So can you please answer my question ?
Also, what happened to the excelforum.com web ?

thanks
 

AliGW

Administrator
Joined
Nov 8, 2015
Messages
1,784
Reaction score
1
Points
38
Location
Ipswich, Suffolk, England
Excel Version(s)
MS 365 (Beta Insider Channel)
ExcelForum is currently down - we don't know what has happened or when it will be back up yet.

You need to read a forum's rules BEFORE you ask for help. Find the time to read the rules NOW.

As you have no regard for the rules, I shan't be helping you any further, as doing so would make me complicit in your rule breaking. Sorry.
 

asdf99

New member
Joined
Jun 30, 2022
Messages
9
Reaction score
0
Points
0
Excel Version(s)
Professional 2021
ExcelForum is currently down - we don't know what has happened or when it will be back up yet.

You need to read a forum's rules BEFORE you ask for help. Find the time to read the rules NOW.

As you have no regard for the rules, I shan't be helping you any further, as doing so would make me complicit in your rule breaking. Sorry.


I have read and will follow all the rules and guideline...

Please let me know if I have missed something, here's where I have posted my questions :

https://www.excelguru.ca/forums/showthread.php?11552-VlookUp-Crawls&p=47765
https://www.mrexcel.com/board/threads/vlook-up-crawls.1209378/page-2#post-5908402
https://techcommunity.microsoft.com/t5/excel/vlook-up-crawls/m-p/3562564
https://www.myonlinetraininghub.com/excel-forum/excel/vlook-up-crawls#p25593
 

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,147
Reaction score
1
Points
38
Excel Version(s)
365
In cell B2 of Sheet1:
Code:
=TEXTJOIN(",",TRUE,FILTER(Sheet2!$A$2:$A$4,ISNUMBER(SEARCH(" " & TRIM(A2) & " "," " & Sheet2!$B$2:$B$4 & " ")),""))
copy down.
 

asdf99

New member
Joined
Jun 30, 2022
Messages
9
Reaction score
0
Points
0
Excel Version(s)
Professional 2021
In cell B2 of Sheet1:
Code:
=TEXTJOIN(",",TRUE,FILTER(Sheet2!$A$2:$A$4,ISNUMBER(SEARCH(" " & TRIM(A2) & " "," " & Sheet2!$B$2:$B$4 & " ")),""))
copy down.


Hi thank you, I've tried this, but then it said function is invalid...

https://prnt.sc/6zb8AGKPClBe


My ms excel version is Microsoft Office LTSC Professional Plus 2021But I am trying to do this google sheet also
 
Top