Use ISNA() to handle this
=IF(ISNA(vlookupformula),"",vlookupformula)

OR

=IF(ISNA(vlookupformula),0,vlookupformula)


If this post helps click Yes
---------------
Jacob Skaria


"GD" wrote:

Hi, I have a set of master data as a named table, for this purpose "MASTER"

I have numerous sub-sets of data, which I want to reference to MASTER for a
certain value. If the key figure is not part of MASTER, the lookup returns
#N/A - I was wondering if there was a way of navigating round this, replacing
with a zero or something?