title: How to do a Vlookup for each row in Google Sheets?
body: <p>I'm creating a Google Sheets to track scores in an event. I have a sheet for each day where we write the name of each player that played that day and the result of each game in which he played. There's a last column with that total.
  I'm trying to create a sheet that would centralize all the important results. For now, I can get all the players name but my issue is to get their totals.
  I managed to get more or less the result that I want with:</p>
  <pre><code>=IF(COUNTIF('05-11'!$A$2:$A$35;$A2)&gt;0;VLOOKUP($A2;'05-11'!$A$2:$R$35;17;false);)
  </code></pre>
  <p>The issue is that I need to drag the formula on each row. I would like to write a formula that could insert in the first cell an that would query all totals in the cells below.
  I think I need something like this but it returns a Value Error:</p>
  <pre><code>=QUERY('05-11'!A2:R;&quot;SELECT R WHERE A MATCHES &quot;&amp;A2:A;)
  </code></pre>
  <p>Keeping in mind that all the players that appears in that centralizing sheet might not have participate that day.</p>
  <p>Here's an example of the document with some data: <a href="https://docs.google.com/spreadsheets/d/1twyIsHxc1YcTxFjWq8JzOAC1lUKO04j_qNhX2a9y8Vg/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1twyIsHxc1YcTxFjWq8JzOAC1lUKO04j_qNhX2a9y8Vg/edit?usp=sharing</a></p>