Hi All

I need help with a excel if statement please what i have is a list containing machine ids

T003478
N000299
T003067
TT90044
all the above are what we call FM only the first to chars should be used as there are over 2000 ids
the second digit is a zero

NR02297
TX00024
TR02175
TC12345
these are called SF

there for if C1 = T0 then print FM or c1=nr print SF



i have this so far


and the error i get is

hope this make sence

thanks

Nigel



edit

I have got it to work if i only put 2 char in c1 useing this



how do i no only pick first 2 chars

also i need altogether 10 if statement i think excel only does 7 is that right

thanks

nigel

I won't redo the whole line but you should get the idea:

Thanks IcemanND

I have this now


which works fine But the problem is now i cant search from this column
A ..... B .......C.........D.......... E......... F
SF 753651 Address Name 2A TX00085
FM 787621 Address Name 2B NR03955
CCM 792373 Address Name 2C NR03024
SF 794187 Address Name 3B NR00127

Column A is the result of above

I need to display how many SF,FM,CCM, there are in 2A,2B.2C.

thanks for your help
Nigel

Wouldn't a "count if" function do?
http://www.ozgrid.com/Excel/count-if.htm

jaclaz