title: Display values from different datasets based on conditions
body: <p>Thanks for reading my question!</p>
  <p>I have two different datasets, each in a different sheet, as below:</p>
  <p>1st table: Sales data from survey (less correct):</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Client</th>
  <th>Yearly Sales</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Apple</td>
  <td>10</td>
  </tr>
  <tr>
  <td>Google</td>
  <td>20</td>
  </tr>
  <tr>
  <td>Nestle</td>
  <td>50</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>2nd table: Sales data from accounting (correct data):</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Client</th>
  <th>Yearly Sales</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Apple</td>
  <td>11</td>
  </tr>
  <tr>
  <td>Google</td>
  <td>20</td>
  </tr>
  <tr>
  <td>Mercedes</td>
  <td>30</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Now, I have to make a summary report of these two. The rules are:</p>
  <ol>
  <li>Each client from both lists must be included (I have accomplished this already; Column &quot;Client&quot;);</li>
  <li>I must include Yearly Sales; <strong>if the data from 2nd table is different from the 1st, the data in 2nd table is included</strong>;</li>
  <li>I'm trying to accomplish this in a spilled range (&quot;Client&quot; is a spilled range);</li>
  <li>There are unique client names in each table (they are all included in my summary report);</li>
  <li>I'm trying to accomplish this without VBA code.</li>
  </ol>
  <p>The summary report must look like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Client</th>
  <th>Yearly Sales</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Apple</td>
  <td>11</td>
  </tr>
  <tr>
  <td>Google</td>
  <td>20</td>
  </tr>
  <tr>
  <td>Mercedes</td>
  <td>30</td>
  </tr>
  <tr>
  <td>Nestle</td>
  <td>50</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Note: I've tried using XLOOKUP and SUMIFS combined with IF statement but I think I'm missing something important because my conditions are not working.</p>