title: Get cell value where column value equals row/column value in second sheet
body: <p>I have two sheets:</p>
  
  <p>Sheet 1:</p>
  
  <pre><code>Callsign  |  Dep ICAO  |  Arr ICAO  | Route
  SWA215       KBUR         KOAK
  AAL258       KLAS         KLAX
  </code></pre>
  
  <p>Sheet 2:</p>
  
  <pre><code>DEP -&gt;  | KLAX          | KBUR        | KLAS        | KSAN
  KSFO    | some route1   some route4   some route7   some route10
  KOAK    | some route2   some route5   some route8   some route11
  KLAX    | some route3   some route6   some route9   some route12
  ARR ^
  </code></pre>
  
  <p>Basically I need to find the route value in <code>Sheet 2</code> where the DEP &amp; ARR column equals the <code>Dep ICAO</code> and <code>Arr ICAO</code> in <code>Sheet 1</code>.</p>
  
  <p>So for example, in sheet one, the route value for SWA215 should return <code>some route5</code>. The route value for AAL258 should return <code>some route9</code>.</p>
  
  <p>I've tried messing with VLOOKUP but I wasn't sure how to incorporate two different sheets. Here's what I had for the function:</p>
  
  <p><code>=VLOOKUP(B2:C2,Sheet 2!A1:Q18,Sheet 2!B2:E4)</code> but it returned <code>#VALUE!</code> error.</p>