title: Finding the cell value from another sheet basing on row/column index
body: <p>I use Excel 2013.</p>
  
  <p>I have two sheets: <code>work_hours</code> and <code>tasks</code>:</p>
  
  <pre><code>#work_hours!
      A            B        C            D
  1   Task         Hours    Cost (sum)   Cost per hour
  2   Task1        5
  3   Task2        3
  4   Task1        2
  
  #tasks!
      A            B            C
  1   Name         Cost (sum)   Description
  2   Task1        500          Desc1
  3   Task2        1000
  </code></pre>
  
  <p>I want to fill the <code>work_hour:C</code> column (<em>Cost (sum)</em>) <strong>automatically</strong> (by formula).</p>
  
  <p>The value of each cell (e.g. C2, C3, C4... let's call it <strong>MY CELL</strong>) should be:</p>
  
  <pre><code>**MY CELL** value should be: The value of cell ($B;x) from `tasks` sheet, 
  where x is the row index in `tasks` where name (A column) match the name
  from the row of **MY CELL**.
  </code></pre>
  
  <p>So in my example the formula should produce:</p>
  
  <pre><code>#work_hours!
      A            B        C            D
  1   Task         Hours    Cost (sum)   Cost per hour
  2   Task1        5        500
  3   Task2        3        1000
  4   Task1        2        500
  </code></pre>
  
  <p>I know that the row index from <code>tasks</code> can be found by:</p>
  
  <pre><code>=MATCH(C2;tasks!A:A;0)
  </code></pre>
  
  <p>Which returs <code>2</code>.</p>
  
  <p><strong>But how to change that formula, so it will return <code>500</code> (value of <code>B</code> column in <code>tasks</code> with the same row index)?</strong></p>