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.
"GEM" wrote in message
...
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!???