title: Excel use Wildcards in LOOKUP RANGE
body: <p>I know one can use wildcards as following</p>
  
  <pre><code>A1&amp;"*"
  </code></pre>
  
  <p>But is it possible to use the wildcards and return a range/array? Sort of like:</p>
  
  <pre><code>A1&amp;"*":A4&amp;"*"
  </code></pre>
  
  <p>Table1</p>
  
  <pre><code>columnA    columnB
  John123    ?
  John243    ?
  John422    ?
  </code></pre>
  
  <p>Table2</p>
  
  <pre><code>columnA    columnB
  John       Smith
  </code></pre>
  
  <p>The goal is to have a MATCH function in Table1 ColumnB that will pull in the value from Table2 ColumnB where the ColumnA's both start with John.</p>
  
  <p>I would like to try something like this to get Table1 ColumnB values</p>
  
  <pre><code>= MATCH( A1 ; Table2!A1:A3 &amp;"*")
  </code></pre>