Forum Discussion
Solved
Search column for keywords and add label
Excel version: 2016, separator is “;” instead of “,” (no XLOOKUP available) Sample file see below I am trying to find a Function which I can place in a helper column which displays a certain...
See the attached version. I merged the tables in columns A and B of the second sheet to a single table.
It's one table with two columns. If you select Formulas > Name Manager you'll see the table definitions.
I see, Thank you for the clarification. I´ve also discovered why there were curly brackets in your formula. It is an 'array' formula, so if you enter it you need to conform it with ctrl+shift+enter. Otherwise it won't work.
Secondly I found that you cannot run the formula on the columns in a Pivot table. I'll try to circumvent this by running it against the original list and then showing the categories in the pivot table.
Edit: it worked, added a new column to the original list. All is working as expected.