title: Excel vba - find row number where colum data (multiple clauses)
body: <p>I need a function in VBA that finds the row number based on 2 where clauses.</p>
  
  <p>Here is the Excel sample:</p>
  
  <pre><code>**     A      B      C      D**
    1    id1    day1   val1   xxx
    2    id2    day1   val2   xxx
    3    id3    day1   val3   xxx
    4    id1    day2   val1   xxx
    5    id2    day2   val2   xxx
    6    id3    day2   val3   xxx
  </code></pre>
  
  <p>I need to find the row number (in this case row number is <strong>2</strong>) where B = "day1" and A = "id2".</p>
  
  <p>Based on the row number, I need to further get the values of other columns, i.e. C2, D2</p>
  
  <p>Hope that the question is clear. </p>
  
  <p>Thank you!</p>