VLookup Value not found ?
I'm not sure if this will work, but try it
=SUMPRODUCT(--(OFFSET(Sheet1!$A15,0,Sheet1!$Q$1,146,1)=$A$15),(O FFSET(Sheet1!$A15,0,Sheet1!$Q$1,146,1)))
HTH,
Barb Reinhardt
"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
|