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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
Click to expand...
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.
 
zPrecede the formulas with an IF(ISERROR(...
-----Original Message-----
I have a spread sheet with a vlookup formula set to
Click to expand...
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.
 
Back
Top