title: Matching Multiple Columns Excel
body: <p>I would like to match 3 columns in a different sheet in excel and if all match then return a result. The data needs to search for the results (i.e not specific rows)</p>
  
  <p>Example:</p>
  
  <p>Sheet1</p>
  
  <pre><code>A   B   C   D   E   F   G
  11  22  33  44  55  66  (Blank)
  22  11  33  55  44  66  (Blank)
  </code></pre>
  
  <p>Sheet2</p>
  
  <pre><code>A   B   C   D   E   F   G
  22  11  33  55  44  66  Yes
  11  22  33  44  55  66  Yes
  33  44  55  66  11  22  No
  11  22  33  44  55  66  No
  22  11  33  55  44  66  No
  </code></pre>
  
  <p>If Column C, D (both) matches C and D in Sheet2 AND G is yes then display yes in Sheet1, otherwise no
  It cannot be a partial match, both columns C and D need to match and G be yes</p>