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
Is the number always the prefix ? If so:
If not, post back with more details (ie all options)=(0&LEFT(C3,2))+0
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
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:
Is that something you can work with?=IFERROR(MATCH(C3,$H$1:$H$10,0),"no match")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks