Have you entered according Names into your workbook? To see defined names, select from menu Formulas > Name Manager. In attached capture you see Names nName01 ... nName07 - one for every string what is searched, and a namr nNameNum, where values of those 7 Names are summarized.

When you need to search for more strings, you have to add a name like nName## for every new string, and add new Names values into nNameNum. after that the formula in worksheet will work.

When Description doesn't have any of strings used in defined Names in it, the worksheet formula returns an error code #VALUE. You can wrap the formula with IFERROR() function, like:

Attached Images

Capture.JPG (122.5 KB, 14 views)