title: How to return text based on 2 criterion
body: <p>I have this sheet: <a href="https://docs.google.com/spreadsheets/d/1tGz0pMeds01kuyK1ZNuvQd9UiiS7iPcRbUL_23mdhfg/edit#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1tGz0pMeds01kuyK1ZNuvQd9UiiS7iPcRbUL_23mdhfg/edit#gid=0</a></p>
  
  <p>I have this formula in column K: <code>=IF(COUNTIF($H:$H, $A15)=0, "No match in h", "")</code></p>
  
  <p>This scans column H and compares each value in H with each cell in column A (A15 in above example) and checks if there is a matching value or not. </p>
  
  <p>It returns no match if there is no match, and nothing in case of match.</p>
  
  <p>I want to add another criteria, which is, if the amounts in column C &amp; G match.</p>
  
  <p>In better words, if H:H compared to A5 yields a match in let's say cell H200. Then in this case, we need to check if G200 has same amount of $$ as C5.</p>
  
  <p>Because we need to match order IDs as well as amounts.</p>
  
  <p>I'm not sure this is possible with built-in formulas, so I was looking for scripts online. I read google's spreadsheet app script documentation and I couldn't find anything.</p>