Hi

I have created an invoice style document. I have used VLOOKUP on the document cells to transport data from another work book. I.e when you type in a product code it brings up the discription and price etc...

All of the Cells that have the VLOOKUP function are displaying "#N/A".

How can I clear the text "#N/A" in these cells so they appear blank but still keep the VLOOKUP formulars working??

I am not a computer wiz so a detailed explination would help.