Grouping transactions by matching key words

Hi Mates,

I am looking for grouping the transactions by matching the key words which included in the description, and to return "OTHER CLAIMS" if not matched with any key words.

Example;

Grouping Ref;
CODE CAT-1
WSTKEVAL PRICE DIFFERENCE
STKTRACN BRANCH TRANSFER


STOCK REVALUATION FOR PRICE UPDATE WSTKEVAL 9118138-1 [Price Difference]
[STKTRACN 334716-1] FROM JBL CON[BT#19007] TO SHJCON [Branch Transfer]


I have attached a sample work sheet.

Appreciated your support.

Thanks.

You did not explain what you expected to see as your results!

So, as a guess:

=IFERROR(LOOKUP(1000,SEARCH(Table2[CODE],[@Column1]),Table2[CAT-1]),"Other claims")

in B2.

Here is a VBA solution

Please Login or Register  to view this content.

How to install your new code

• Copy the Excel VBA code
• Select the workbook in which you want to store the Excel VBA code
• Press Alt+F11 to open the Visual Basic Editor
• Choose Insert > Module
• Edit > Paste the macro into the module that appeared
• Close the VBEditor
• Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

• Press Alt-F8 to open the macro list
• Select a macro in the list
• Click the Run button

Change this line of code

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.