=if(isna(vlookup....),"",(vlookup....))

Also, try this for a bunch more other "features":
http://www.myexpertsonline.com/freedls/invoices.zip

*******************
~Anne Troy

www.OfficeArticles.com


"Beth" wrote in message
...
I am creating an invoice at work, and the owner will be using it as well.
The problem is she doesn't know anything about computers so I am trying to
make it as easy as possible. I have the invoice set up so that all she
will
have to do is type in the customers name, and then by using the vlookup
function the address and other info of the customer is automatically
entered
into the invoice. Second she needs to enter the COA number (Certificate
of
Authenticity which is how we distinguish each autograph) and then I also
have
a vlookupfunction for that so it will automatically display the
description
of the piece and the price. The problem is say I have the vlookup carried
down the column so you can enter up to 10 pieces, well if the customer
only
buys 2 then the other 8 prices say #N/A because the vlookup formula
doesn't
work without the coa number. How can I make it so that doesn't show up???
because when that error does show up, then the autosum for the total price
of
the items doesn't work and it screws up the rest of the invoice!

Help would be greatly appreciated asap.
Thank you