G
Guest
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
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