Results 1 to 9 of 9

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

Threaded View

  1. #1
    Registered User
    Join Date
    10-05-2021
    Location
    Hong Kong
    MS-Off Ver
    MS Office 2019
    Posts
    4

    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.
    Attached Files Attached Files
    Last edited by samnew12u; 10-05-2021 at 11:49 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 03-11-2020, 07:41 AM
  2. Align an item name from its short description via keywords
    By kissmydrone in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-21-2014, 03:55 AM
  3. Replies: 0
    Last Post: 11-09-2013, 01:18 AM
  4. [SOLVED] HDI - Return multiple keywords in a text column based on a set of available keywords
    By zneiley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2013, 01:32 PM
  5. Populate new cells based on keywords in description field
    By kprum13 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-16-2012, 10:39 AM
  6. Ensuring cell is filled with one of many keywords
    By lightsandsirens in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-04-2009, 10:58 PM
  7. Excel function same description but different result
    By heng in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-12-2005, 03:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1