title: Libreoffice Calc / Excel - Multiple IF statments
body: <p>I'm at a loss here, I'm just wanting to match the contents of a cell to a partial value and if true, set the value in a new cell.</p>
  <p>Colum E2 contents (2 rows):</p>
  <pre><code>MCDONALD'S #49019 QF5
  THRIFTY FOODS #5649 NEW YORK
  </code></pre>
  <p>In cell E3 for example I have this:</p>
  <pre><code>=IF(ISERR(SEARCH(&quot;*MCDONALD'S*&quot;, E2)), &quot;no match&quot;, &quot;fast food&quot;),
  IF(ISERR(SEARCH(&quot;*THRIFTY FOODS*&quot;, E2)), &quot;no match&quot;, &quot;grocery&quot;)
  </code></pre>
  <p>It results in an error.</p>
  <p>Now if I just have the first condition:</p>
  <pre><code>=IF(ISERR(SEARCH(&quot;*MCDONALD'S*&quot;, E2)), &quot;no match&quot;, &quot;fast food&quot;)
  </code></pre>
  <p>Then is works just fine, so how do I get this to work with multiple conditions?</p>
  <p>Also trying this, with no success. It successfully matches the first criteria, but when the second criteria matches I just get the &quot;Error&quot; value...</p>
  <pre><code>=IFERROR( IF(SEARCH(&quot;MCDONALD'S&quot;, E3),&quot;Fast Food&quot;, IF(SEARCH(&quot;THRIFTY&quot;, E3),&quot;Grocery&quot;, &quot;No Match&quot; ) ) ,&quot;Error&quot;) 
  </code></pre>