Mar 20 2021 08:09 PM
Hi guys,
I am not sure excel can do what I need but here we go:
In cell "A" I am being provided with a category with potentially lots of words. Based on one of those words I would like to categorise cell "B". Example below:
Cell "A" phrase is: "NBA teams from New York and Boston"
Based on the word "Boston" I would like cell "B" to automaticially be categorised as "Boston".
How do I do that?
I can make a XLOOKUP formel where I tell Excel that Boston = Boston, but what I need is for Excel to find out by itself that if cell "A" has the word "Boston" in it (no matter where it is placed), then cell "B" should automaticially be categorised as "Boston".
How do I do this? I really appreciate any kind of help.
Best regards,
Henrik
Mar 20 2021 09:39 PM
Mar 20 2021 11:39 PM
Mar 21 2021 07:49 AM
@dmacgme & @Subodh_Tiwari_sktneer thank you so much for replying.
I have attached an excelark to this message which should explain my problem.
The "problem" is that I cannot edit the input (Colonne B) because it is given to me by a third party. Hope it make sense and that you can help me out.
Best regards,
Henne
Mar 21 2021 08:56 AM - edited Mar 21 2021 08:57 AM
Do you want formula in column F in the second table? If so, please try this...
In F3
=IF([@[If input contains…]]="","",IF(COUNTIF(Tabel1[Input (given to me by third party)],"*"&[@[If input contains…]]&"*"),[@[If input contains…]],""))
and then copy it down.
If this is not what you are trying to achieve, please rephrase your requirement based on sample file.
Mar 21 2021 01:10 PM