toomany if statements

[Anala]

Hello everybody:

I've been having a little problem with the if formula. This is my first time that i post in english so forgive me if i make to many gramatical mistakes.

well the thing is that i have data input with sales description and i want to write some especific words in one cell base on some key words in the description that is in other cell, for example

description
AF C PS 2 ITS Imp Tape VSM + 9840

and the formula is:
=IF(ISNUMBER(SEARCH("DOCUMENT",$F306)),"Mail",IF(ISNUMBER(SEARCH("MAIL",$F306)),"Mail",IF(ISNUMBER(SEARCH("VIDEO",$F306)),"VideoSur",IF(ISNUMBER(SEARCH("DCS",$F306)),"DCS",IF(ISNUMBER(FINDB("ESS",$F306)),"ESS",IF(ISNUMBER(SEARCH("ITS",$F306)),"IMP","Sales1"))))))

that will return the word IMP base on the product description above

for now i have three diferent formulas because the if statements are too many and i can nest more than 6 or 7 if statements in one formula.

So what i want is to find a way to be able to nest more than 7 if statements

hope you can help me i already check previous posts and i couldn't fine anything...

thanks..

Anala

 

[shades]

Check out this recommended site ( http://216.92.17.166/board2/viewtopic.php?t=49750 ):

http://www.cpearson.com/excel/nested.htm

 

[Andrew Poulsom]

Some alternatives here:

http://j-walk.com/ss/excel/usertips/tip080.htm

 

[Aladin Akyurek]

Something like...

Book1
	A	B	C	D	E	F
1					Mail	Mail
2	AFCPS2ITSImpTapeVSM+9840	IMP			Video	VideoSur
3	dfVideo6NoTape+8786	VideoSur			DCS	DCS
4	AFFPS2VideoImp+1000	VideoSur			ESS	ESS
5	AFESSIMPnotape	ESS			ITS	IMP
6
Sheet1

The formula in B2 is:

=INDEX($F$1:$F$5,MATCH(TRUE,ISNUMBER(SEARCH($E$1:$E$5,A2)),0))

which must be confirmed with control+shift+enter instead of just with enter.

 

[Greg Truby]

About time Aladin showed up with one of his magic array formulas. I was bustin' my head tryin' to figure out what it should look like.