+ Reply to Thread
Results 1 to 3 of 3

Find part of cell in table and give back assigned category

  1. #1
    Registered User
    Join Date
    08-19-2020
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    6

    Find part of cell in table and give back assigned category

    Hello all

    I just signed up to this forum and was trying to find a solution for my problem in the previous posts and questions, but unfortunately I cannot find anything.
    So I am hoping someone can help me with the following problem:

    I have a list of values, in which I am searching for certain phrases. If the phrase if found I want to assign the category which I have assigned to this. The phrase I am looking for, can be anywhere in the cell.

    Description Category
    #Jan-20 - FX Clearing - posted FX
    Feb-20 - FX Clearing FX

    My lookup table would look like the following:

    Value Category
    FX Clearing FX
    Clean-up CHECK
    PH1 PH1


    I hope it is halfway clear, what I am trying to do here and thank you very much for your help in advance.

    P

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Find part of cell in table and give back assigned category

    Is it are you looking for?

    Please Login or Register  to view this content.
    Attached Images Attached Images
    Quang PT

  3. #3
    Registered User
    Join Date
    08-19-2020
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Find part of cell in table and give back assigned category

    perfect, that works nicely. Thank you for your quick help. Really appreciated.

+ 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: 7
    Last Post: 06-20-2020, 01:55 AM
  2. Generate a list of products based on what category it's assigned to
    By kitpierce in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-14-2016, 05:00 PM
  3. Inputed Transactions Get Assigned to Category
    By spurredhal in forum Excel General
    Replies: 5
    Last Post: 03-10-2013, 01:49 PM
  4. Replies: 4
    Last Post: 12-20-2012, 04:33 AM
  5. Count values that are assigned a specific category
    By rbalrich in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-02-2012, 07:36 PM
  6. Saving Outlook Emails When Assigned to a Specific CATEGORY
    By jmr.noun in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2012, 03:18 AM
  7. [SOLVED] Excel should be able to give back the colorcode of a cell via celi
    By Bart Schouw in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-07-2005, 06:06 PM

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