I have been trying several solutions suggested in diverse fora for a few hours but nothing seems to work (see here, for example). So this is my problem:
- I have a long column of text strings which contain some keywords and lots of rubbish.
- I would like to generate a new clean value in another column, depending on which one of the keywords were found in the first one.
- I have a little table with the keywords/strings to be found and the desired return values.
- I have tried nested IFs, but it becomes too complex and not flexible. I would prefer a function that relies on that table.