I am struggling with the following. I have a lookup table called LookupTbl which consists of keywords in column A and then a category in column B.
I then have a seperate table on another worksheet with a set of data. One column on this table is called “Description”. Each cell in this column is a string of text.
My problem is to look through the text in each cell in the “Description” column and if the cell contains any of the keywords in the lookupTbl (Column A), it should return the category in column B.
It should also only return the category for the first keyword that is found in the string of text.
I hope this make sense and that someone can help me.