You can do something along these lines:

=IF(ISERROR(VLOOKUP(A1,$K1:$L21,2),0,VLOOKUP(A1,$K 1:$L21,2))

If would prefer nothing replace the 0 with "", or "Your Message Goes Here".

--
Kevin Backmann


"Pammy" wrote:

I have a vlookup and when there is nothing for it to lookup as of yet, I get
a #Na, is there an =if iserror fomula I can add to the vlookup that will let
me add a "0" instead of the #na?