title: Formula to look up values from multiple Non-Contiguous ranges
body: <p>I have a lot of arrays in a sheet, all the arrays are the same size. The top left cell contains Array plus a number which is unique to that array, so the first array will have Array 1 in the top left corner. Underneath that each array has two random numbers, for example 2, 3.  </p>
  
  <p>In a separate sheet, I have a table with the Array numbers across the top, and the random numbers going down. And were the column for the array name, and row for the number intersect, I need the value of a cell to the right in the same row as the number, in the array.  </p>
  
  <p>For example in the table below I would need to find the value 7, given Array 1 and number 2. And if there is not data, It needs to write False, or none or something similar.<br>
  On the data sheet there are 70 arrays, and 40 different number, with each array containing 6 numbers.</p>
  
  <p><br>
  <kbd>Array 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><kbd>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><kbd>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><br>
  <kbd>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><kbd>0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><kbd>7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><br>
  <kbd>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><kbd>0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><kbd> 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><br><br>
  <kbd>Array 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><kbd>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><kbd>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><br>
  <kbd>7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><kbd>0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><kbd>7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><br>
  <kbd>9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><kbd>0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><kbd> 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><br><br>
  <kbd>Array 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><kbd>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><kbd>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><br>
  <kbd>12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><kbd>0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><kbd>7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><br>
  <kbd>88&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><kbd>0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><kbd> 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</kbd><br></p>