We have created a spreadsheet for our purchase orders which we fill out and
send it to our suppliers. We use a pull-down menu with the Data Validation
function in the first column and the VLOOKUP function for the other columns
for the material, product ID and pricing. Because we don't ususally enter
material (from the pull-down menu) in every row we have a #NA error message
show up in the cells that have the VLOOKUP formula.

Is there any option that we can use so that #NA error message does not show
in the unsed cells?? Because we send these sheets directly to the supplier we
are trying to make the sheet look a little better and get rid of the #NA
messages in the cells.

Thank You in Advance.