Error Message In Cell

[Kearcomm]

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.

 

[Paul B]

Kearcomm, use something like this,

=IF(B4="","",VLOOKUP(B4,mytable,2,FALSE))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Kearcomm]

Thank You

Kearcomm, use something like this,

=IF(B4="","",VLOOKUP(B4,mytable,2,FALSE))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Paul B]

Your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003