Help With VLOOKUP Please

[ady armstrong]

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.

[NBVC]

Add an IFERROR statement around the current fomrula...

eg.

=IFERROR(YourFormula,"")

where YourFormula is your current VLOOKUP without the = in front.