software

=IF($I$2=quot;Activequot;,VLOOKUP($E6,Data!$G$4:$AT$1587,2 8,0),quot;0quot;)

I have this formula above in a cell. I want to add that if the vlookup
doesn't find anything and returns a #N/A than give me ZERO.

I'm doing this so I don't get #n/a in the column and my totals will add up
without giving me #n/a.

Any help? B.

=IF($I$2=quot;Activequot;,
IF(ISNA(MATCH($E6,Data!$G$4:$G$1587,0)),
0,
VLOOKUP($E6,Data!$G$4:$AT$1587,28,0)
),quot;0quot;
)
You can get rid of all the line breaks; I was just using them to pair off
the parens. Basically, the idea is to replace the vlookup() with
if(isna(match()),0,vlookup()). That is, if a match fails (and therefore the
vlookup will fail), return 0, otherwise process the lookup.
--Bruce

quot;BSantosquot; wrote:

gt; =IF($I$2=quot;Activequot;,VLOOKUP($E6,Data!$G$4:$AT$1587,2 8,0),quot;0quot;)
gt;
gt; I have this formula above in a cell. I want to add that if the vlookup
gt; doesn't find anything and returns a #N/A than give me ZERO.
gt;
gt; I'm doing this so I don't get #n/a in the column and my totals will add up
gt; without giving me #n/a.
gt;
gt; Any help? B.