title: vLookup Match different lookup array
body: <p>Can someone please advise the correct method to use so that I can dynamically change the <code>Lookup_Array</code> in a Match condition.</p>
  
  <p>The following formula works fine;</p>
  
  <pre><code>=VLOOKUP(F22,A26:O2000,MATCH(A9,A26:O26,0),FALSE)
  </code></pre>
  
  <p>However based on other criteria I would like the Lookup Array to be different, instead of being <code>A26:026</code> it would be <code>A34:O34</code>.</p>