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.
Bart_VdE You don't mention the Excel version you work with, but the formulas in the attached file should work in all.