cant get this formula to work

petethecat

Board Regular
Joined
Oct 25, 2011
Messages
63
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)

MB7603(I)
MB7603(II)
VW7679(I)
VW7679(II)
MB6664(I)
MB6664(II)

Any idea what I am doing wrong?

<colgroup><col></colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,109,518
Messages
5,529,311
Members
409,862
Latest member
lbisacca
Top