Formula Question

[grant862]

I am trying to write a formula to say:

If this cell contains this phrase then have the cell equal ""

I have these values
js = Jan
jdg = John
bhm = Brian
rst = Ryan
kle = Kate

So the cell will contain either one of these abbreviations (js, jdg..etc) and if that cell contains one of them then i want the formula to equal Jan, John..etc.

in english the formula is something like =if((A1=*js*,"Jan"),A1=*jdg*,"John")...etc

The other thing is that the cell that contains the abbreviation also contains other text such as "New Retailer - [JS]" or "New Vendor - [jdg]". so i want to just search for "js" or "jdg" in the cell and if that cell has that value then have it equal Jan or John...etc

Any suggestions....Thank you

[daddylonglegs]

Here's one way

=LOOKUP(2^15,SEARCH({"js";"jdg";"bhm";"rst";"kle"},A1),{"Jan";"John";"Brian";"Ryan";"Kate"})

[grant862]

Here's one way

=LOOKUP(2^15,SEARCH({"js";"jdg";"bhm";"rst";"kle"},A1),{"Jan";"John";"Brian";"Ryan";"Kate"})

That works perfect...thanks

1 more thing...can you explain this formula a bit, What exactly it is doing...as in what is the 2^15 for. What does that do exactly. Otherwise the formula kind of make sense to me.

thanks

[grant862]

That works perfect...thanks

1 more thing...can you explain this formula a bit, What exactly it is doing...as in what is the 2^15 for. What does that do exactly. Otherwise the formula kind of make sense to me.

thanks

Nevermind i think i figured it out. Thanks