You could use Format|conditional formatting to hide errors (white text on white
fill).

Or you could change your =vlookup() formula:

=if(iserror(yourformula)),"",yourformula)



Shaya M wrote:

I have created a general order form in excel using vlookups, i would like to
know if in repeating the function throughout a colomn is it possible to not
have the #N/A show if there is nothing entered into it

--

Dave Peterson