title: Excel Nested IF Statements For Column Comparison
body: <p>I have two columns (E, F) reading in data from two other worksheets. The goal is to identify a value that may exist only in 1 or both of the referenced worksheets.</p>
  
  <p>I want to compare the values between each row in column E against column F knowing that either may contain "0":</p>
  
  <p><code>IF E39 &lt;&gt; 0 AND F39 = 0 THEN +E39 
  ELSE IF E39 = 0 AND F39 &lt;&gt; 0 THEN +F39 
  ELSE IF E39 &lt;&gt; 0 AND F39 &lt;&gt; 0 THEN (EXACT(E39,F39), +E39, "Mismatch")
  ELSE E39 = 0 AND F39 = 0 THEN "Value not found"</code></p>
  
  <p>Addtional Info:</p>
  
  <p>I have cell E3 keying off of cell A3 value to find a Coding Values:</p>
  
  <pre><code> =IFERROR(VLOOKUP(FinalVersion!$A3,worksheet1!$A$2:$D$11696,4,FALSE),0)
  </code></pre>
  
  <p>I have cell F3 doing the exact same thing but against a different worksheet:</p>
  
  <pre><code> =IFERROR(VLOOKUP(FinalVersion!$A3,worksheet2!$A$2:$D$1000,4,FALSE),0)
  </code></pre>
  
  <p>Any thoughts on how to accomplish this? If it were SQL, I could easily code, but sadly I'm stumbling within Excel.</p>