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))))

Perhaps replace your empty cells conditions with
=IF(C5="",0,Vlookup... etc..
The "" is causing the error

BTW what is the OR function for?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you I will try the "0". I was grasping at straws since I am just learning vlookup. I took the formula from a spreadsheet someone else had made and modified it.

You're welcome, but don't put the 0 between double quotes !

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post