Rowan,
I did the formula, but answer didn't automatically appear in E1. What am I
missing? Also, "How to copy to end of data.
thanks
Monkeydo

"monkeydo" wrote:

help!!
I need to be able to put a code # in column C, then automatically column E
would be $14.32 each time I would put that code in column C.I have tried all
day to do this.
p.s. Column G would be nice to automatically put in there also, but I don't
want to ask for too much. If I could even do the first two, I would be happy.


using office 2003