If Thens

[sammon28]

I know this is probably easy, but I haven't been able to make it work. This is what I'm trying to do: If Cell M2 contains a certain string of Characters, I want it to return "Fund" if it does, and "Ad Hoc" if it doesn't. I've got it to where it will return Ad Hoc for everything but can't get it to return Fund no matter what changes I make. =IF(ISNUMBER(SEARCH("AZ",M2,)),M2,"Ad Hoc")

What am I doing wrong? I've tried replacing the 2nd M2 with lots of different things, but it doesn't ever come out right.

 

[mrshl9898]

Looks like the extra comma is throwing out a VALUE error in SEARCH

=IF(ISNUMBER(SEARCH("AZ",M2,)),M2,"Ad Hoc")

Try:

=IF(ISNUMBER(SEARCH("AZ",M2)),M2,"Ad Hoc")

 

[sammon28]

Looks like the extra comma is throwing out a VALUE error in SEARCH

=IF(ISNUMBER(SEARCH("AZ",M2,)),M2,"Ad Hoc")

Try:

=IF(ISNUMBER(SEARCH("AZ",M2)),M2,"Ad Hoc")

So that makes it return the word "Ad Hoc" in the right cells, but it returns the ENTIRE M2 cell instead of the word "Fund". How do I get it to do that?

 

[Fluff]

How about
=IF(ISNUMBER(SEARCH("AZ",M2)),"Fund","Ad Hoc")