+ Reply to Thread
Results 1 to 3 of 3

If specific text is found in cell, then return a number

  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    Philadelphia
    MS-Off Ver
    Excel 2007
    Posts
    32

    If specific text is found in cell, then return a number

    Hello,

    I am working on an output file that lists a number of different data points. I am hoping to use an equation that looks within a specific cell for text. If it finds that text, then return a value in another cell. While that is pretty easy, I am looking for the equation to basically return certain data based on different names it finds. So f it sees Hello Chris, then return just Chris in column B. If it sees Hello Brad, then return Brad, etc. I was thinking of doing an IF statement, but thought I might run into a nesting issue. Any suggestions?

    Column A Column B
    Hello Chris Chris
    Hello Jeff Jeff
    Hello Brad Brad
    Hello Larry Larry
    Hello Mike Mike
    Hello Red Red
    Hello Orange Orange
    Hello Blue Blue
    Hello Green Green

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: If specific text is found in cell, then return a number

    Simply..

    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.
    which will return blank if it does not find "Hello"
    Last edited by Ace_XL; 01-31-2013 at 04:40 PM.
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: If specific text is found in cell, then return a number

    If you have a list of the mathces you are looking for this Array Formula (Cntrl+Shift+Enter, not just Enter) will return the first item in the list that matches:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Drag down

    Hope this helps
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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