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