title: How to find the row and column of a certain string in a Google Spreadsheet through Google App Scripts
body: <p>So I am trying to make a Google spreadsheet that records an ID and an amount. I would like to Input data through the Google web app script. This data will be an integer that will be used to find the row of the ID (The column will be given) in the spreadsheet. Then I want it to update the amount in the next column. Please help with this</p>
  
  <p>I'm using MIT app inventor to get the ID
  I have figured that part but this is where I'm struggling!</p>
  
  <pre><code>function searchString(){
    var search_string = id
    var textFinder = sheet.createTextFinder(search_string)
    var search_row = textFinder.findNext().getRow()
  }
  </code></pre>
  
  <p>I tried using this code. Didn't work for me.</p>