Autofill question

[darksides]

Hi,

I'm trying to do this


Code:
--------------------

---------------------------
| B | C |
|-------------------------|
| vic | vic2fxs | when I write vic2fxs in the C column it autofill B column with vic
| vic | vic2bri | when I write vic2bri in the C column it autofill B column with vic
| vic | vic4fxs | when I write vic4fxs in the C column it autofill B column with vic
| wic | wic1-enet | when I write wic-1-enet in the C column it autofill B column with wic
| switch | sw2950 | when I write sw2950 in the C column it autofill B column with switch
---------------------------

--------------------


Help me to resolve this question...and sorry for my english

Thanks

 

[Die_Another_Day]

This can be done without code:
B1 = "=If(C1 = "","",If(Left(C1,2) = "sw","switch",Left(C1,3))"

HTH

Charles