+ Reply to Thread
Results 1 to 3 of 3

If Contains Formula

  1. 02-02-2011, 01:51 PM #1
    mpeters
    mpeters is offline
    Registered User
    Join Date
    02-02-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2007
    Posts
    1

    If Contains Formula

    I'm trying to create a formula based on a cell containing an exact phrase. For Instance,

    If C3 contains "1 - Cold Prospect", then value = 1
    If C3 contains "2 - Medium Prospect", then value = 2

    I have 10 "if" possibilities. Is it possible to create a formula for this?

    Thanks for any help that can be provided!

    Mark
    Reply With QuoteRegister To Reply
  2. 02-02-2011, 02:02 PM #2
    DonkeyOte
    DonkeyOte is offline
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: If Contains Formula

    Is the number always the prefix ? If so:

    Please Login or Register  to view this content.
    If not, post back with more details (ie all options)
    My Recommended Reading:

    Volatility
    Sumproduct & Arrays
    Pivot Intro
    Email from XL - VBA & Outlook VBA
    Function Dictionary & Function Translations
    Dynamic Named Ranges
    Reply With QuoteRegister To Reply
  3. 02-02-2011, 02:08 PM #3
    Ron Coderre
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: If Contains Formula

    Assuming your posted examples are simplified and the real categories won't actually have the rank as the first character...
    Try this:

    With H1:H10 containing your categories...
    V2 - Cold Prospect
    C7 - Medium Prospect
    Z99 - Indifferent Prospect
    x05 - Promising Prospect
    ...etc

    Arrange those items in rank order and use this formula:
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1