title: Find row and set value in column google app scripts
body: <p>I have a 2d array:</p>
  <pre><code>const arr = [ [ 'John Doe',
      'john@something.com',
      'Some text here',
      '' ],
    [ 'Steven Smith',
      'steven@something.com',
      'Another irrelevant text here',
      '' ],
  ]
  </code></pre>
  <p>I want to find a row in the tab that matches the name in each array in this list and add a text value in the last column (where the '' is).</p>
  <p>For example:</p>
  <pre><code>const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = ss.getSheetByName(sheetName);
  const range = sheet.getDataRange()
  const data = range.getValues()
  const people = data.slice(1)
  </code></pre>
  <p>if a name in <code>arr</code> is found in <code>people</code>, add the text 'Found' in the last column in <code>people</code> for that name.</p>
  <p><code>people</code> looks like this:</p>
  <pre><code>[ [ 'John Doe',
      'john@something.com',
      'Some text here',
      '' ] ]
  </code></pre>
  <p>I was able to find the match using this:</p>
  <pre><code>const peopleTarget = arr.map(person =&gt; people.find(el =&gt; el[0] === person[0]))
  </code></pre>
  <p>However, I need the <strong>row number</strong> to be able to set a value.
  I know I need the <code>getRange</code> to be able to use <code>setValue</code> but I'm having difficulty grabbing the row number based on matching value between two arrays.</p>
  <p>Any help is appreciated.</p>