use IFERROR

e.g.

=IFERROR(VLOOKUP(....),"No")