title: Get a cell value from two different cells
body: <p>I have been trying to find out how to get a cell value based on two other cells. The formula I'm using is:</p>
  <pre><code>=ARRAYFORMULA(IF(NOT(ISBLANK(C3)),
  IF(C3=&quot;&quot;,&quot;&quot;,
  IF((C3-NOW())&gt;0, &quot;Call restaurant in &quot;&amp;ROUND(C3-NOW(),2)&amp;&quot; days&quot;, 
  &quot;Call now&quot;)),))
  </code></pre>
  <p>Is it possible to add a formula that will detect if there is text in the cell in column V as indicated in green below? The message will be &quot;do not call&quot; else if the cell is empty the message will be &quot;call restaurant in&quot; or &quot;call now&quot; based on the left time.</p>
  <p><a href="https://i.stack.imgur.com/Ph72u.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Ph72u.png" alt="enter image description here" /></a></p>