The double quotation mark ("") will output a blank space. Change that to
whatever you want your error message to read (i.e. "no match")

--
David Billigmeier


"Mjoddie" wrote:

> I get it. You do not write Quot you put a " mark in!!
>
> Thank you,
>
> Mike
>
> "David Billigmeier" wrote:
>
> > Hello -
> > You can add a check before doing the vlookup:
> >
> > =IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))
> >
> > Hope that helps,
> > --
> > David Billigmeier
> >
> >
> > "Mjoddie" wrote:
> >
> > > How do I get the N/A's in cells to not appear after doing a vlookup and there
> > > is no value that match in the 2 spreadsheets? What I have is a complete
> > > inventory and movement of my product and I bring in a customers inventory and
> > > they do not stock all the numbers in my line. In any cell that the customer
> > > does not stock my product I get a #N/A.