hi

I have an invoice that i have designed in excel an have a vlookup value so
that when i select a material from a drop down list it automatically puts the
correct price in another cell. however if there is no materials in one of
the cells it presents a "value not available error" and puts N/A in the cost
cell. this in turn then messes up the calculations for adding up the
matterial costs and VAT. Is there anyway of making it dissapear or making it
say 0 if there are no materials entered in any of the material cells boxes?

many thanks