title: How to search row index using cell value
body: <p>I am using google spreadsheet API v4 for java.</p>
  
  <p>My Spreadsheet looks something like this -</p>
  
  <pre><code>    User    Message       Time
  --------------------------------
  
      User1    My Message    10:30
      User2    User2 msg     3:40
      User3    User3 msg     1:30
      User2    User2 msg       
      User4    User4 msg     4:00 
  </code></pre>
  
  <p>I want to find row index with User 'User2' and Time bank (empty value).
  After that, I would like to use this row index to add time value in that row. 
  Is it possible to search row by cell values without knowing range or index?</p>
  
  <p>In above example, it should return me only second last row index as it matches to the criteria (User='User2' and Time='').
  or even better, is there any find and replace API, which will find row criteria (User='User2' and Time='') and replace Time value from '' to '3:30'?</p>
  
  <p>I went through google docs, but could not find one according to my need.
  Thanks.</p>
  
  <p><strong>Edit:</strong></p>
  
  <p>I found a formula to find cell address which needs to be updated.</p>
  
  <pre><code>=ADDRESS(MATCH("User2",A1:A4000),3)
  </code></pre>
  
  <p>For example used in this question, this formula will return '$C$4' address, which is expected. I tested this by evaluating this formula in spreadsheet manually. Is there any way using Google spreadsheet API V4 to evaluate this formula using Java code? </p>