Posted by Forenzix on August 27, 2001 2:34 AM
I'm creating an invoice worksheet that populates cells
with VLOOKUP. Now I don't want Excel to show #N/A when the value is not found. How do I do that?
I currently use the following formula :
if A17 is empty, he shows the empty cell
if there is something in A17 Excel will go to the Items sheet to find the corresonding item and show it in the cell. However, when he does not find the item, he will show #N/A. I've tried different approaches to do this, but none worked...