Try this then:

=IF(OR(LEFT(E7,2)="CU",LEFT(E7,2)="GU"),"Module"," Tube")

I think I've got the negative logic right!

Hope this helps.

Pete