=IF(ISNA(VLOOKUP([your vlookup critieria]),"",IF(F$2<0,VLOOKUP([your
vlookup]),0))

Dave
--
Brevity is the soul of wit.


"Dale" wrote:

I am using the following conditional formula
=IF(F$2<0,VLOOKUP($B6,Jan!$E$2:$W$1200,19,FALSE), 0)

So if the cell F2 is populated it will complete a vlookup on a second tab
within the worksheet.

Issue: The list on the second tab does not contain all the items in the
list referenced by $B6, so I get a #N/A return.

I want to remove the #N/A as a returned value because I am summing the
column of values returned by the Vlookup. With a value of #N/A, the column
sums to a #N/A.

Can I nest an iserror or an isan statement in the formula to remove the #N/A
and return a value of 0?