My spreadsheet is a pricing sheet with formulae using lookup in another
worksheet so it fills in the rest of the row automatically. All rows below
what has been filled in show #N/A in one column and ### in 3 columns. How
can I hide this so the sheet looks clean and still maintain the formulae?