I've got a fairly simple sheet that uses drop-down boxes to select items to order, and cells that do a VLOOKUP later on to calculate price. By default, there is nothing in the input cells, thus the calculated price cells are normally displaying #NA, until the items are selected. I would like to suppress the #NA warning to give it a cleaner look.

The first formula resulting in a #NA result is: =VLOOKUP(F6,Y6:Z9,2,FALSE) + 12.5
The second is: =IF(E6="Y",W6,G6).
(wherein E6 and F6 are drop-down list entries).

Thanks in advance.