title: Lookup using table with separated columns
body: <p>I would like to use <code>VLOOKUP()</code> using a table input consisting of columns that are not next to each other. </p>
  
  <p><strong>Example</strong></p>
  
  <pre><code>MyCell = VLOOKUP(A1, MyTable, 2, FALSE)
  MyTable = B1:B10 and D1:D10
  </code></pre>
  
  <p>Is there a way of making this operation work using a <em>lookup</em> function or any other worksheet function? Now I get an error.</p>
  
  <p>Thanks in advance.</p>
  
  <p><em>Edit:
  It's because the table is very large and I'm afraid that the operation will slow down the application if I use the entire table as input</em></p>