+ Reply to Thread
Results 1 to 9 of 9

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

  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.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,101

    Re: Is there any function in Excel where the keywords are filled based on the 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.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Registered User
    Join Date
    09-23-2021
    Location
    New York
    MS-Off Ver
    2016
    Posts
    7

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

    Categorize keywords in Excel?

    Then press Ctrl + Shift + Enter to receive the first result. Drag the fill handle down to the cells where you wish to apply this formula, and all text strings will be grouped into the precise group you require. but I'd need more specific detail

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,101

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

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

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

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

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

    dani.aniston96 please look at the post again, I have updated it.

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

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

    HI AliGW, thank you for your reply. I have written more details. Hope the example gives you more details.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,101

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

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

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

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

    Sorry AliGW, I attached the file now. Please take a look. By the way, I tried the Vlookup function and tried the Index match function both doesn't seem to work, maybe I am doing something wrong or I don't know how to use them.

  9. #9
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,235

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

    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
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

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. [SOLVED] 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