title: Google Sheets Double Array Lookup
body: <h2>INPUT core data sheet:</h2>
  <p><img src="https://i.stack.imgur.com/0GRC4.png" alt="INPUT core date" /></p>
  <h2>OUTPUT data sheet:</h2>
  <p><img src="https://i.stack.imgur.com/aRbtB.png" alt="OUTPUT desired data" /></p>
  <p>Essentially I am wanting to have the output sheet do a lookup on the input sheet, and Match column C(INPUT) where it matches in Column A(OUTPUT) of and ALSO match column A(INPUT) where it matching in D1:1(OUTPUT), and return column H(INPUT), and if there is no match for the member in D1:1, then show empty</p>
  <p>The end result would look like this:</p>
  <pre><code>name                    AshHoIe        Barktooth      Bria Janson...
  
  Aayla Secura           7*L85G8P12539  7*L85G8P12539  7*L85G8P12539
  
  Admiral Ackbar         7*L85G8P12539  7*L85G8P12539
  
  Ahsoka Tano            7*L85G8P12539                 7*L85G8P12539
  
  Ahsoka Tano (Fulcrum)                 7*L85G8P12539
  
  Amilyn Holdo           etc.
  </code></pre>
  <p>A better example in the Google sheet below.</p>
  <p>Would love to do this with either a single formula per row or single formula for entire array list.</p>
  <p>Editable Google spreadsheet <a href="https://docs.google.com/spreadsheets/d/1D2tigIfv6knAX57r2qW-C90_r9kYWN0CvN3cwvmGNIc/edit?usp=sharing" rel="nofollow noreferrer">here</a>.</p>