title: How to lookup cells based on variable unique data, Google Sheets
body: <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>DATE</th>
  <th>NAME</th>
  <th>CX#</th>
  <th>DATA</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>11/7/2021</td>
  <td>Alex</td>
  <td>CX55</td>
  <td>1.34</td>
  </tr>
  <tr>
  <td>11/7/2021</td>
  <td>Linda</td>
  <td>CX43</td>
  <td>22.9</td>
  </tr>
  <tr>
  <td>11/7/2021</td>
  <td>Loki</td>
  <td>CX109</td>
  <td>3.43</td>
  </tr>
  <tr>
  <td>11/8/2021</td>
  <td>Alex</td>
  <td>CX 12</td>
  <td>23</td>
  </tr>
  <tr>
  <td>11/8/2021</td>
  <td>Linda</td>
  <td>CX 113</td>
  <td>2.49</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>What I am trying to do is, paste in a master sheet of data for a week, which is broken down by date, and by person. I need to formulate charts using data with a lookup where the data from Alex can be pulled and populated into another sheet for charting. Since the dates are going to be changing every week as new data is pasted/populated, I cannot do a normal vlookup and match based on unique <em>static</em> strings. Not only are dates changing, but even the names themselves day to day and week to week. Ideally I'd end up with something like this</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>DATE</th>
  <th>NAME</th>
  <th>DATA</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>11/7/2021</td>
  <td>Alex</td>
  <td>1.34</td>
  </tr>
  <tr>
  <td>11/8/2021</td>
  <td>Alex</td>
  <td>23</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>using logic which is flexible enough to group when the data column is dynamic, as well as the name column. Maybe I am just not thinking if it in a way that makes sense with the functions available. Any guidance would help!</p>