title: Excel Matrix: Search Value and provide value next to it
body: <p>I have an Excel table that is a bit messy with different dates below each other.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">User</th>
  <th style="text-align: center;">Date0</th>
  <th style="text-align: center;">property0</th>
  <th style="text-align: center;">Date1</th>
  <th style="text-align: right;">property1</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">User1</td>
  <td style="text-align: center;">28/10/21</td>
  <td style="text-align: center;">1000</td>
  <td style="text-align: center;">27/10/21</td>
  <td style="text-align: right;">3000</td>
  </tr>
  <tr>
  <td style="text-align: left;">User2</td>
  <td style="text-align: center;">27/10/21</td>
  <td style="text-align: center;">2000</td>
  <td style="text-align: center;">26/10/21</td>
  <td style="text-align: right;">300</td>
  </tr>
  <tr>
  <td style="text-align: left;">User1</td>
  <td style="text-align: center;">28/10/21</td>
  <td style="text-align: center;">2000</td>
  <td style="text-align: center;">25/10/21</td>
  <td style="text-align: right;">100</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I would want to have one separate column for each date as it can be seen below:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">User</th>
  <th style="text-align: center;">Date1</th>
  <th style="text-align: center;">property1</th>
  <th style="text-align: center;">Date2</th>
  <th style="text-align: center;">property2</th>
  <th style="text-align: center;">Date3</th>
  <th style="text-align: center;">property3</th>
  <th style="text-align: center;">Date 4</th>
  <th style="text-align: right;">property4</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">User1</td>
  <td style="text-align: center;">28/10/21</td>
  <td style="text-align: center;">1000</td>
  <td style="text-align: center;">27/10/21</td>
  <td style="text-align: center;">3000</td>
  <td style="text-align: center;">26/10/21</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;">25/10/21</td>
  <td style="text-align: right;"></td>
  </tr>
  <tr>
  <td style="text-align: left;">User2</td>
  <td style="text-align: center;">28/10/21</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;">27/10/21</td>
  <td style="text-align: center;">2000</td>
  <td style="text-align: center;">26/10/21</td>
  <td style="text-align: center;">300</td>
  <td style="text-align: center;">25/10/21</td>
  <td style="text-align: right;"></td>
  </tr>
  <tr>
  <td style="text-align: left;">User1</td>
  <td style="text-align: center;">28/10/21</td>
  <td style="text-align: center;">2000</td>
  <td style="text-align: center;">27/10/21</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;">26/10/21</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;">25/10/21</td>
  <td style="text-align: right;">100</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Therefore, I wanted to create a new table with the date values and use an INDEX function that checks the user name and the date to provide the property value. However, I can only search the date in one column in the index function, is there any way to search in the whole matrix and give the value that is next to this date value?</p>