Multiple IF statements in one cell?

[sunshine1185]

I have a statement that looks as follows:

=IF(ISERROR(SEARCH("[A]", [CELL])),"","")

Where A is the term that you are looking for and B is what you want written in the cell if A is found.

I hope this makes sense. I need to basically search for more than one A, giving me another B answer along with each A. How would I do this? Please let me know if I need to clarify anything but any help is greatly appreciated!

 

[TheCman81]

Something like this

=IF(ISERROR(SEARCH(AND("[A]","[A]","[A]","[A]",[CELL])),"","")

If they all need to match what you are searching for then use AND, if only some then use OR

 

[sunshine1185]

Something like this

=IF(ISERROR(SEARCH(AND("[A]","[A]","[A]","[A]",[CELL])),"","")

If they all need to match what you are searching for then use AND, if only some then use OR

Unfortunately this did not work.. said I entered too many arguments for the function. Also how would I do this if I want each A to match up with its own B?

 

[Soggy]

I think I understand what you want but just in case here are three options with the last being what I think you want.

This one will tell you if it appears ion the cell:
=IF(ISERROR(FIND("[A]",[CELL],1))=FALSE,"","")

This one will tell you if it appears more than once:
=IF(LEN([CELL])-LEN(SUBSTITUTE([CELL],"[A]",""))>1,"","")

and this one will get you a result depending on how many times it occurs.
=IF(LEN([CELL])-LEN(SUBSTITUTE([CELL],"[A]",""))>0,VLOOKUP(LEN([CELL])-LEN(SUBSTITUTE([CELL],"[A]","")),$L$2:$M$16,2,0),"")
You will have to set up a range to lookup gainst I have as L2:M16 which is effectively your .

So L2 will be 1 and M2 will be and L3 will be 2 and M3 will be [C] and so on.