VLOOKUP - reporting #N/A
 

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?

VLOOKUP - reporting #N/A
 

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?

VLOOKUP - reporting #N/A
 

Hi
try using ISNA for error handling, eg
=IF(ISNA(your formula),"",your formula)
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"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?