Using IFERROR Function to return a blank cell or 0 quantity

[tl17339]

I appreciate anyone's help on this. If this VLOOKUP statement returns a "#N/A" error, I would prefer the cell to be displayed blank, or return a zero. How do I use the IFERROR function to accomplish this? Thanks - Tom

=VLOOKUP(A4,idoc,10,FALSE)

 

[mrshl9898]

IFERROR(VLOOKUP(A4,idoc,10,FALSE),"") for blank or IFERROR(VLOOKUP(A4,idoc,10,FALSE),0) for 0

 

[gmittar]

IFERROR(VLOOKUP(A4,idoc,10,FALSE),"") for blank or IFERROR(VLOOKUP(A4,idoc,10,FALSE),0) for 0

IFERROR(VLOOKUP(A4,idoc,10,FALSE),"") for blank or IFERROR(VLOOKUP(A4,idoc,10,FALSE),"") for blank

 

[tl17339]

Thank-you very much for the quick reply to my question, it worked perfect and my worksheet is much less cluttered... Much appreciated - Tom