Is me, on another computer in another office!

Got it working with Vlookup (great wee function)

Thanks for your help.

Kirstie Adam


"Kirstie Adam" (nospam) wrote in message
...
Hi,

I have a nested if with 9 statements, which won't work. I've looked this
up and read i need to convert to code.

Can i please have some help? I know VB for access, but not really done
much with excel.

I have 9 different car types, and each one has a different value.

I just want it to say, after a cell in range B2:B1000 is changed, if that
cell = car type 1, the cell in C2:C2000 changes to the value £100 and if
it changes to car type 2, the cell in column C changes to value £200
etc.....

Thanks,

Kirstie