title: Google Sheets Search from Database and insert into specific cell on edit
body: <p>i need some help from someone who is more experience than me.
  I've the following formula</p>
  <pre><code>=WENNFEHLER(SVERWEIS($B$3;$B6:C;{2};0))
  </code></pre>
  <p>and the following script</p>
  <pre><code>function copyIntoCell() {
    var spreadsheet = SpreadsheetApp.getActive();
    spreadsheet.getRange('C3').activate();
    spreadsheet.getRange('A3').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
  };
  </code></pre>
  <p>How is it possible to add the formula into the script and also make it &quot;onEdit&quot; when a name entered into B3 it should auto insert the number into C3 from B6:C when B3 match with the database.</p>
  <p>Also is it possible to autocomplete when I enter a word into B3 it suggest me the names from the database with the word I tipped in? This one is not important but would be nice.</p>
  <p><a href="https://docs.google.com/spreadsheets/d/12kreTB4QnaV_qnI5jXeqA9hK7iswKXLCi4k8vxvO3Bg/edit?usp=sharing" rel="nofollow noreferrer">Here is the example</a></p>
  <p>Thanks for any help and idea I can get to complete what I looking for.</p>