Adding Cells, Get Error.

  • Thread starter Thread starter GEM
  • Start date Start date
G

GEM

I have a simple forumla, =A1+B1+C1+D1

Every cell, A1, B1, C1 and D1 have vlookup functions. Some of them are
blank, because information is still not entered for the vlookup function to
find.

My question is this, cell E1 has the simple formula =A1+B1+C1+D1, but if I
have no information on any of the four cells which have the vlookup function
I get #VALUE!. How can I leave E1 blank instead of having #VALUE!???
 
In your vlookup cells, enter the formula

=if(iserror(vlookup(.......)),0,vlookup(.....))

That way, if the vlookup returns an error, the formula will enter a 0
instead of an error, and your sum function will work.
 
Back
Top