VLOOKUP - reporting #N/A

G

GD

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

Jacob Skaria

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

OR

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


If this post helps click Yes
 
F

Francis

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
 
Top