You can check each portion to see if it returns an error first:

=if(isna(firstvlookup),0,firstvlookup)
+if(isna(2ndvlookup),0,2ndvlookup)

If you're using xl2007, you could look at =iferror() in excel's help. You won't
have to duplicate each vlookup formula.



Jeff C wrote:

I am using the following:

=VLOOKUP($A15,$A$81:$AB$124,Q$1,FALSE)+VLOOKUP($A1 5,$A$126:$AB$160,Q$1,FALSE)

Where $A15 may not exist in either of the arrays or only in one of the two.

How do I allow for this so I get a value rather than the #N/A?

Thanks in advance
--
Jeff C
Live Well .. Be Happy In All You Do

--

Dave Peterson