Giving a list of 4 words in a single drop down tab a numerical value for each word.

[lchalk]

Hi,

I am new to this forum so I'm sorry if I have made any mistakes in my post. I am looking to give a list of 4 words which are within a drop down tab all separate numerical values. If you could shed some light on this. I have tried to use the following formula and it won't work:

=IF(ISNUMBER(SEARCH("good",C4)),"1",IF(ISNUMBER(SEARCH("moderate",C4)),"2", IF(ISNUMBER(SEARCH(''awkward'',C4)),''3'',IF(ISNUMBER(SEARCH(''N/A'',C4)),''4'',))))

Thanks in advance for any help on this.

 

[Snakehips]

lchalk,

Welcome to MrExcel.

Does something like this help?

Excel 2007
	B	C
1		This?
2	Good	1
3	Moderate	3
4	Awkward	2
5	N/A	4
Sheet1

Cell Formulas
Range	Formula
C2	=SEARCH(LEFT(B2,1),"GAMN")

 

[lchalk]

lchalk,

Welcome to MrExcel.

Does something like this help?

Excel 2007

	B	C
1		This?
2	Good	1
3	Moderate	3
4	Awkward	2
5	N/A	4

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula C2 =SEARCH(LEFT(B2,1),"GAMN") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Thanks, this is what I needed.