+ Reply to Thread
Results 1 to 2 of 2

Search for multiple texts in cell, return specific text

  1. #1
    Registered User
    Join Date
    11-24-2014
    Location
    norway
    MS-Off Ver
    2010
    Posts
    37

    Search for multiple texts in cell, return specific text

    Ok, this is a great challange! Honor to the one who solves this one

    I'm making a budget.
    I want to sort my spendings into categories. My spendings are downloaded as a spreadsheet from my bank. It looks like this:

    Details Sum Category
    VISA Mc Donalds -130,00
    138766 Statoil -640,00
    76234 TAXI 20141127 -357,00
    23454 BurgerKing -130,00

    The categories in this example would be:

    lunch
    gas

    Now, I want to search for multiple strings in the A-column and return the correct category for each spending. F.x: I will search for texts like "donalds","burger","oil". If no match is found, the return value should be an empty string. The result should look like:

    Details Sum Category
    VISA Mc Donalds -130,00 lunch
    138766 Statoil -640,00 gas
    76234 TAXI 20141127 -357,00
    23454 BurgerKing -130,00 lunch

    I have tried
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    , but I have only been successful with searching for one string. Using macro is an option, but I want to try solving this one without use of macro.

    I'll be greatful for all the help you can provide!
    Last edited by mariur89; 11-24-2014 at 06:40 PM.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello mariur89,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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: 10
    Last Post: 09-18-2014, 09:36 AM
  2. How to search for occurrence of multiple texts in same row/cell
    By coolfundaz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-13-2014, 01:12 AM
  3. [SOLVED] VBA to search cell containing specific text and return common value
    By hate0lif3 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-30-2014, 09:41 AM
  4. Search the text in 3rd cell by using texts in 2 cells
    By Shinaj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-09-2014, 08:08 AM
  5. [SOLVED] search for specific text in a file and return a value to a cell based on the results
    By JJGF in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-03-2013, 07:00 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