I am trying to calculate several different situations in one cell by using vlookup but if one cell is blank I get a value error. I have part of the formula but I am missing something. If I want it to pull from three different cells it works if all three have numbers in them but if one is empty I get a value error.

Here is the formula I have right now:



=IF(C5="","",(VLOOKUP($C$5,'benchmark plan rates'!$B$2:$C$102,2,FALSE))+IF(D5="","",OR(VLOOKU P($D$5,'benchmark plan rates'!$B$2:$C$102,2,FALSE)))+IF(D5="","",(VLOOKUP ($C$7,'benchmark plan rates'!$E$3:$F$5,2,FALSE))))