title: Excel MATCH range without specific CELL
body: <p>after a deep search on the internet i gave up.</p>
  
  <p>My "simple" question would be:
  <em>How can I add two ranges in a formula, preferably in MATCH?</em></p>
  
  <p>I want to search a range like A1:A7 + A9:A20 and thus <strong>not</strong> include A8 in my range.</p>
  
  <p>Is this possible? Please help me out</p>