title: Skipping blank cells with an Index/Match formula
body: <p>I've got several databases containing 100/1,000's of rows where the information is presented something like this:</p>
  
  <p><img src="https://i.stack.imgur.com/CAye9.png" alt="https://i.stack.imgur.com/CAye9.png"></p>
  
  <p>I need to get all the information relevant to each company onto one row; I'm not able to do a simple Sort &amp; Filter as nearly every company has a different level of detail, so information ends up in the wrong rows. Looks like the best option is an Index/Match formula, but my current formula </p>
  
  <pre><code>=INDEX(Sheet1!B:B,MATCH(Sheet2!$A2,Sheet1!$A:$A,0) 
  </code></pre>
  
  <p>returns zeros for any result where the first Index/Match result is blank:</p>
  
  <p><img src="https://i.stack.imgur.com/aP9MO.png" alt="https://i.stack.imgur.com/aP9MO.png"></p>
  
  <p>How can I write the formula so that it skips the blank cells? I'd prefer not to have to use VBA however any advice would be very much appreciated.</p>