title: In Excel, need to populate a cell with a value based on multiple conditions in corresponding table
body: <p>I am editing this entire thing because I feel I can be more clear now, and I think this question can be very useful for a lot of people:</p>
  
  <p><a href="https://i.stack.imgur.com/N1l0J.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/N1l0J.png" alt="Screen Capture"></a>
  Original image here: <a href="http://i.imgur.com/Givg96T.png?1[/img]" rel="nofollow noreferrer">http://i.imgur.com/Givg96T.png?1[/img]</a></p>
  
  <p>I guess I can't post a picture, so here is a link to what I am referencing.</p>
  
  <p>Based on the shown formula, Cell D1 says compliant because it found the referenced text (B1) in the cited range column (D). This is fine, I get how to do this part. The problem is that I want it to say compliant only if it finds that text, which it did, AND ALSO has a Y next to that particular cell in column G, not a N as shown. So ideally it would say 'not sufficient' rather than compliant, because although it found the next, there is an N next to it, not a Y. This needs to apply to a range and not just one row as there will be many rows of this same data. </p>
  
  <p>Essentially the question I want cell D1 to answer is this: Do you find anything that says the contents of cell B1 in column D? And if so, is there a Y next to it in column G? If the answer is yes to both of those questions, say "compliant". If not, say 'Not sufficient'.</p>
  
  <p>Thank you to anyone who can offer any advice, I greatly appreciate it.</p>