Instead of returning a 0?

=if(vlookup()="","",vlookup())

And to get rid of the #n/a's:

=if(iserror(vlookup()),"missing",if(vlookup()=""," ",vlookup()))



Eaglered wrote:

I need Vlookup to return a blank if the appropriate cell is empty.

Thank you so much . . . .Y'all have been extremely helpful!!

J.

--

Dave Peterson