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.
Bookmarks