I have this formula in cell A2
=LOOKUP(B2,{" ",19,50},{" ","1","2"})+A1
if I enter a value in B2 it works fine but if I leave it blank I get an
error that a value is not available.
What I would like is that if there is no value in B2 then A2 would stay
blank.