Forum Discussion
Search column for keywords and add label
See the attached version. I merged the tables in columns A and B of the second sheet to a single table.
HansVogelaar when I download your version of my sample file, the function works. Strangely, when I typ it in the original file it doesn't. When digging a bit further I noticed when clicking on let's say Data!C2 for example, and then clicking in the formula bar and somewhere else again, the formula stops working. Strangely enough no difference inside the formula bar can be seen...
Any idea what is happening?
You had two separate tables in columns A and B on the second sheet. I merged them into one table.
HansVogelaar could you elaborate on that? In the file you send I still see 2 columns.
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.