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.

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" wrote in message
...
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.

Thank You

"Paul B" wrote:

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" wrote in message
...
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.

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

"Kearcomm" wrote in message
...
Thank You

"Paul B" wrote:

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" wrote in message
...
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.