Sum of cells if cells contain vlookup function that is returning #N/A

[Guest]

I have a spread sheet with a vlookup formula set to False. Some of the cells are returning #N/A because no data exists in the lookup table. I would like to write a sum formula that includes those cells but the formula returns the #N/A message

Here are the formulas being used: =VLOOKUP(C2,'R_C Table'!$D$65:$N$85,11,FALSE
an
=SUM(L3-M3

The results of the sum formula are #N/A.

 

[Frank Kabel]

Hi
change your vlookup fomula as follows:
=IF(ISNA(VLOOKUP(C2,'R_C Table'!
$D$65:$N$85,11,FALSE)),0,VLOOKUP(C2,'R_C Table'!
$D$65:$N$85,11,FALSE))

-----Original Message-----
I have a spread sheet with a vlookup formula set to

False. Some of the cells are returning #N/A because no
data exists in the lookup table. I would like to write a
sum formula that includes those cells but the formula
returns the #N/A message.

 

[Guest]

zPrecede the formulas with an IF(ISERROR(...

-----Original Message-----
I have a spread sheet with a vlookup formula set to

False. Some of the cells are returning #N/A because no
data exists in the lookup table. I would like to write a
sum formula that includes those cells but the formula
returns the #N/A message.