title: excel match value(get row) in two-dimensional array
body: <p>I have the following structure in my excel sheet.</p>
  
  <pre><code>          E           F           G        H        
        ---------   ---------    ------    -------      
   2 |  blah        sometext     atext      smth
   3 |  textval     accc
   4 |  test        avfr
   5 |  check       
   6 |  ertyui      
   7 |  
  </code></pre>
  
  <p>Can you suggest a way using <strong>EXCEL functions</strong> (<strong>not VBA</strong>) of getting back the row of a matching string? </p>
  
  <p>For example: given <code>test</code> I need to get back <code>4</code>, given <code>ertyui</code> <code>6</code></p>
  
  <p>I need: </p>
  
  <ul>
  <li><p>the lookup to be done in all the columns of this two-dimensional array and</p></li>
  <li><p>have the function in one cell only </p></li>
  </ul>