cant get this formula to work

[petethecat]

I have this formula:

=IF(ISNUMBER(SEARCH("I",I35)),"1",IF(ISNUMBER(SEARCH("II",I35)),"2",IF(ISNUMBER(SEARCH("III",I35)),"3")))

my results keep coming back with a 1

this is the text i am interrogating: (assume the top cell is I35)

[TABLE="width: 115"]
<colgroup><col></colgroup><tbody>[TR]
[TD]MB7603(I)[/TD]
[/TR]
[TR]
[TD]MB7603(II)[/TD]
[/TR]
[TR]
[TD]VW7679(I)[/TD]
[/TR]
[TR]
[TD]VW7679(II)[/TD]
[/TR]
[TR]
[TD]MB6664(I)[/TD]
[/TR]
[TR]
[TD]MB6664(II)

Any idea what I am doing wrong?[/TD]
[/TR]
</tbody>[/TABLE]

 

[sandy666]

maybe use "(I)" instead of "I" only
the rest is similar

 

[petethecat]

Great! worked a treat! Thanks loads.......

 

[sandy666]

You are welcome
Have a nice day