Is there any function in Excel where the keywords are filled based on the description?

Hi, is there any function in Excel where the keywords are filled based on the description? Basically, I have a lot of products purchased and I have the products name in the description. Now based on the description from invoices, I have to manually search the products from the product list and the specific item ID and fill that item ID in a column. I was wondering if there is any function where the key sentence is identified from the description column and based on that automatically fill the item ID in another column.

For example, one of the products we bought is "Protin powder x100gram" the product description is "Protin powder x100gram - Natural sweetener " and the item ID in my file for that product is "PP100", so I was wondering if there is any way to match the product name from the description and input the relevant item ID number in the column next to the product description.

Welcome to the forum.

The broad answer is possibly yes, but we'd need more specific detail.

There are instructions at the top of the page explaining how to attach your sample workbook.

Where's the formula you are proposing, dani.aniston96???

I don't think this has anything to do with categorising keywords, actually.

Where is the workbook I asked to see? Please attach it.

It's still not clear to me exactly what you are trying to do, but my best guess right now is that you are trying to do a "fuzzy" lookup -- a text lookup where the search string and the text in the database are never exact matches. If I'm right, you may find that you want something that will do a fuzzy lookup, like this add-in from Microsoft: https://www.microsoft.com/en-us/down....aspx?id=15011