title: Excel - Lookup value with a condition
body: <p>I've been trying to do the following:</p>
  
  <ul>
  <li><code>Sheet1</code>, lookup value <code>A3</code> in <code>Data</code></li>
  <li><code>Data</code>, check whether the found value has a <code>1</code> in column <code>M</code>
  
  <ul>
  <li>Yes: Paste the value of column <code>K</code> from <code>Data</code> in column <code>B3</code> in <code>Sheet1</code></li>
  <li>No: Carry on searching through the sheet and display <code>0</code> if nothing is found</li>
  </ul></li>
  </ul>
  
  <p>This is what I have so far, it finds the correct K value, but I need to enter shift+ctrl+enter to get the value ...</p>
  
  <pre><code>=INDEX('TLN Data'!$B$1:$Z$15000; MATCH(1;(A3='TLN Data'!$B$1:$B$15000)*(1='TLN Data'!$M$1:$M$15000);0); 10)
  </code></pre>
  
  <p>All help is much appreciated!</p>
  
  <p>--</p>
  
  <p>Sheet1</p>
  
  <p><img src="https://i.stack.imgur.com/VaxtR.jpg" alt="enter image description here"></p>
  
  <p>TLN Data</p>
  
  <p><img src="https://i.stack.imgur.com/LB3v4.jpg" alt="enter image description here"></p>