VlookUp Crawls

[FONT=&quot]OK I understood now what you meant... because I thought one forum may have different people in the community[/FONT]
 
[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]
 
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
 
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.
 
AliGW said:
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.
Click to expand...


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
 
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.
 
p45cal said:
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.
Click to expand...


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
 
You must log in or register to reply here.
Back
Top