1. What formula are you using? Copy it directly from the formula bar so we
can see exactly what it is.
2. If your invoice has 27 lines, you need a range of 27 cells for your price
overrides. In your Priceoverride sheet, you need to set up a range (say B2
to B28) to support overriding each line separately.
3. You say "not getting a blank cell when there is no other info in the
refered cell" Well, what are you getting? What do you mean by "refered
cell"?

Rather than send a copy of the workbook, I'd rather you explain things
clearly and keep the whole conversation in the message so I don't have to go
back and forth to other messages. That way I don't have to worry about
viruses, and you get your answer much more quickly.

Regards,
Fred.

"cjbarron5" wrote in message
...

doesnt seem to work means im not getting a blank cell when there is no
other
info in the refered cell
my invoice has 27 lines for items so when I try to override one price it
over rides all the prices
hope this clears things up
I can send you a copy of the workbook if you like
thanks
"Fred Smith" wrote:

What does "doesnt seem to work" mean? What happens? What results do you
get?

What does "still showing in all the other cells" mean?

Regards,
Fred.

"cjbarron5" wrote in message
...
ok I tryed the new formula and it doesnt seem to work its still showing
in
all the other cells any more ideas????
thanks