title: index indirect.ext match formula
body: <p>I am using this formula below. It does work, but unfortunately once the match has found I do not get the proper column result back. I would expect the information out of column E, but I get the cell info back of another column. So what do I need to do in order to get always the results back of column E? </p>
  
  <pre><code>=INDEX(INDIRECT.EXT("'"&amp;BO13&amp;"
  ["&amp;BO17&amp;"]"&amp;BO18&amp;"'!"&amp;BU5),MATCH(A75,INDIRECT.EXT("'"&amp;BO13&amp;"
  ["&amp;BO17&amp;"]"&amp;BO18&amp;"'!"&amp;BU7),0),MATCH(AA75,INDIRECT.EXT("'"&amp;BO13&amp;"
  ["&amp;BO17&amp;"]"&amp;BO18&amp;"'!"&amp;BU8),0))
  </code></pre>
  
  <ul>
  <li>BO13 = Path</li>
  <li>BO17 = Filename.xlsx</li>
  <li>BO18 = SheetName</li>
  <li>BU5 = $E$3:$E$5 --> lookup range</li>
  <li>BU7 = $B$2:$B$5 --> including a certain name</li>
  <li>BU8 = $C$2:$C$5 --> including a certain number</li>
  <li>A75 = lookup value which is a name</li>
  <li>AA75 = lookup value which is a number</li>
  </ul>