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.
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.